Forum Subject: GUS plugin problem
Posted on: 06/05/05 02:10pm
By: garfy
Hi when i tried to view Gus under User options i get this message
An SQL error has occured. Please see error.log for details.
and when i checked the log this is what i got
so what is wrong please tell me
An SQL error has occured. Please see error.log for details.
and when i checked the log this is what i got
Sun Jun 5 11:06:36 2005 - 1044: Access denied for user: 'altermed_reno@localhost' to database 'altermed_database'. SQL in question: CREATE TEMPORARY TABLE gl_temp20056 (
uid int(10) NOT NULL default '1',
ip varchar(20) default '0.0.0.0',
host varchar(75) default '',
page varchar(50) default '',
username varchar(16) default '',
referer varchar(255) default '',
request varchar(10) default '',
query_string varchar(255) default '',
`date` date default NULL,
`time` time NOT NULL default '00:00:00',
ua_id smallint(5) unsigned NOT NULL default '0',
KEY uid (uid),
KEY ip (ip),
KEY page (page),
KEY refer (referer),
KEY ua_id (ua_id),
KEY `date` (`date`)
)
uid int(10) NOT NULL default '1',
ip varchar(20) default '0.0.0.0',
host varchar(75) default '',
page varchar(50) default '',
username varchar(16) default '',
referer varchar(255) default '',
request varchar(10) default '',
query_string varchar(255) default '',
`date` date default NULL,
`time` time NOT NULL default '00:00:00',
ua_id smallint(5) unsigned NOT NULL default '0',
KEY uid (uid),
KEY ip (ip),
KEY page (page),
KEY refer (referer),
KEY ua_id (ua_id),
KEY `date` (`date`)
)
so what is wrong please tell me
GUS plugin problem
Posted on: 06/05/05 08:05pm
By: rjrufo
It appears that GUS couldn't access the database table needed, probably because your database settings are incorrect.
I'm not sure what you meant by "view", but from the error message, it looks like you tried installing GUS? If so, you may have to check to see if any of the tables remain that GUS tries to install before the error occurs. An early version that I tested for asmaloney[*1] had an error that didn't clean up the database tables, but it only happened once. Subsequent installs went without a problem.
What version are you using? If you are using a version older than 1.2.0, I suggest that you download[*2] the latest version, it is much more refined.
I'm not sure what you meant by "view", but from the error message, it looks like you tried installing GUS? If so, you may have to check to see if any of the tables remain that GUS tries to install before the error occurs. An early version that I tested for asmaloney[*1] had an error that didn't clean up the database tables, but it only happened once. Subsequent installs went without a problem.
What version are you using? If you are using a version older than 1.2.0, I suggest that you download[*2] the latest version, it is much more refined.
GUS plugin problem
Posted on: 06/05/05 08:09pm
By: garfy
i have the latest version
not gui administration worked at first but as soon as somebody visited my site after install of GUS i could not go into gus menu in user on the left side of my site
not gui administration worked at first but as soon as somebody visited my site after install of GUS i could not go into gus menu in user on the left side of my site
GUS plugin problem
Posted on: 06/19/05 09:54am
By: casper
Hi!
Been using GUS since the start.
Now I got pagerendering-times up to 6 sec, used to be 0,4 sec.
When disabling GUS it speeds up again.
Uses GUS on two sites, one with about 1000 hits pr day, and one with only 50 hits.
The times are the same.
Had to disable GUS now, has anybody some sugestions how to fix this?
GUS tables are almost empty, so thats not the issue.
Been using GUS since the start.
Now I got pagerendering-times up to 6 sec, used to be 0,4 sec.
When disabling GUS it speeds up again.
Uses GUS on two sites, one with about 1000 hits pr day, and one with only 50 hits.
The times are the same.
Had to disable GUS now, has anybody some sugestions how to fix this?
GUS tables are almost empty, so thats not the issue.
GUS plugin problem
Posted on: 06/19/05 10:26am
By: asmaloney
Casper,
Since your tables are almost empty, then it must be something in the code that adds the stats to the DB. This would leave me to believe that it's some network call that's taking a long time to timeout. I suspect it's the call to gethostbyaddr().
If you could try something for me it would be helpful. In functions.inc, find the call to gethostbyaddr() in the GUS_addStats() function and change this:
to this:
Just so we can see if that's the culprit. Note that this will mean you won't get any reverse DNS lookups.
I will try to find a way to shorten the timeout for this call.
- Andy
Since your tables are almost empty, then it must be something in the code that adds the stats to the DB. This would leave me to believe that it's some network call that's taking a long time to timeout. I suspect it's the call to gethostbyaddr().
If you could try something for me it would be helpful. In functions.inc, find the call to gethostbyaddr() in the GUS_addStats() function and change this:
. "', host='" . @gethostbyaddr( $_SERVER['REMOTE_ADDR'] )
to this:
. "', host='" . $_SERVER['REMOTE_ADDR']
Just so we can see if that's the culprit. Note that this will mean you won't get any reverse DNS lookups.
I will try to find a way to shorten the timeout for this call.
- Andy
GUS plugin problem
Posted on: 06/19/05 10:43am
By: casper
Tnx Andy!
Changing in functions.inc worked, the site are now back to normal
Changing in functions.inc worked, the site are now back to normal
GUS plugin problem
Posted on: 06/19/05 11:09am
By: asmaloney
Great! I'll see if I can find a better solution for this...
- Andy
GUS plugin problem
Posted on: 06/21/05 10:21am
By: Anonymous (duvide)
the GUS seems to work ok, but I am wondering why there is the GL menu gone when I go to the stats. When I klick to see the details the menu is back.
What I haven't found so far is how to delete the stats without doing it in the DB directly.
Thank you/Frank
What I haven't found so far is how to delete the stats without doing it in the DB directly.
Thank you/Frank
GUS plugin problem
Posted on: 06/21/05 10:26am
By: Anonymous (duvide)
Silly me, deleting the stuff I found just now. This was too obvious for me!
...
...
GUS plugin problem
Posted on: 06/21/05 12:21pm
By: Anonymous (duvide)
now I get this error:
Warning: fopen(/home/xxx/domains/xxx.com/public_html/gus/cache/day_php_month_6_year_2005_anon_1.html): failed to open stream: No such file or directory in /home/xxx/domains/xxx.com/gl/plugins/gus/functions.inc on line 700
any idea?
Thank you/Frank
Warning: fopen(/home/xxx/domains/xxx.com/public_html/gus/cache/day_php_month_6_year_2005_anon_1.html): failed to open stream: No such file or directory in /home/xxx/domains/xxx.com/gl/plugins/gus/functions.inc on line 700
any idea?
Thank you/Frank
GUS plugin problem
Posted on: 06/21/05 12:52pm
By: asmaloney
duvide,
This must be a bug with the cache - I must admit that I've never actually used it [
], but I must have changed something from the old stats that broke it.
I'll take a look at it, but in the meantime you can turn off the cache and it should work.
- Andy
This must be a bug with the cache - I must admit that I've never actually used it [
], but I must have changed something from the old stats that broke it.I'll take a look at it, but in the meantime you can turn off the cache and it should work.
- Andy
GUS plugin problem
Posted on: 06/21/05 01:09pm
By: Anonymous (duvide)
Thanks Andy, that did the trick with the sql error!
But I am still wondering why the menus is gone on some pages?
Tanks/Frank
But I am still wondering why the menus is gone on some pages?
Tanks/Frank
GUS plugin problem
Posted on: 06/21/05 01:22pm
By: asmaloney
[QUOTE BY= duvide]But I am still wondering why the menus is gone on some pages?[/QUOTE]
Ah. So am I This was the behaviour of the stats plugin. Someone mentioned this a while ago and I just haven't looked into it yet.
I have a new version coming out 'Really Soon Now'. When that's done, I'll look at this and the cache issue.
- Andy
Ah. So am I This was the behaviour of the stats plugin. Someone mentioned this a while ago and I just haven't looked into it yet.
I have a new version coming out 'Really Soon Now'. When that's done, I'll look at this and the cache issue.
- Andy
GUS plugin problem
Posted on: 07/31/05 11:17am
By: asmaloney
duvide,
The menu problem can be solved by editing the following three files: comments.php, day.php, and index.php
When you find this [near the end of the files]:
$display = COM_siteHeader('none') . $display;
change it to this:
$display = COM_siteHeader() . $display;
I'll add a configuration option for this in a future version.
As for the cache thing - I'm rather busy with other projects right now and it's low priority for me, so unless someone wants to fix it and submit the fixes to me, it will be 'a while'.
- Andy
The menu problem can be solved by editing the following three files: comments.php, day.php, and index.php
When you find this [near the end of the files]:
$display = COM_siteHeader('none') . $display;
change it to this:
$display = COM_siteHeader() . $display;
I'll add a configuration option for this in a future version.
As for the cache thing - I'm rather busy with other projects right now and it's low priority for me, so unless someone wants to fix it and submit the fixes to me, it will be 'a while'.
- Andy
GUS plugin problem
Posted on: 08/01/05 08:13am
By: Anonymous (duvide)
thank you asmaloney, now the menus work too!
I also installed version 1.3.2 and everything works find. good work.
As for the cache, I hardly remember that there was a problem...
Frank
I also installed version 1.3.2 and everything works find. good work.
As for the cache, I hardly remember that there was a problem...
Frank
GUS plugin problem
Posted on: 08/10/05 08:04pm
By: suprsidr
Sorry to bug you Andy, but..
why does gus break my glmenu when I activate the user stats option - expected ')',
and I get this error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE ID = '1' LIMIT 1' at line 1. SQL in question: SELECT OuterFrame FROM WHERE ID = '1' LIMIT 1
when I manually go to gus/index.php
I can go to day.php and all the rest. Mysql version 4.0.21
Also how's the G2 integration going? very exciting!
Thanks
why does gus break my glmenu when I activate the user stats option - expected ')',
and I get this error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE ID = '1' LIMIT 1' at line 1. SQL in question: SELECT OuterFrame FROM WHERE ID = '1' LIMIT 1
when I manually go to gus/index.php
I can go to day.php and all the rest. Mysql version 4.0.21
Also how's the G2 integration going? very exciting!
Thanks
GUS plugin problem
Posted on: 08/10/05 11:30pm
By: asmaloney
[QUOTE BY= suprsidr] Sorry to bug you Andy, but..
why does gus break my glmenu when I activate the user stats option - expected ')',
[/QUOTE]
I'm not sure what you mean here - are you talking about the $_GUS_user option in the config.php file? What so you mean by 'glmenu'?
[QUOTE BY= suprsidr]
and I get this error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE ID = '1' LIMIT 1' at line 1. SQL in question: SELECT OuterFrame FROM WHERE ID = '1' LIMIT 1
when I manually go to gus/index.php
[/QUOTE]
Do you have the $_GUS_phplinks option set to 1? I inherited that from the stats plugin, but have never tested it because I don't have phplinks installed. In fact, I don't even know what phplinks is :-)
[QUOTE BY= suprsidr]
Also how's the G2 integration going?
[/QUOTE]
Slowly - real life is keeping me rather busy lately. I have a plugin which installs, maps the GL admin user to the G2 admin user, and creates G2 users on the fly whenever a GL user goes to the gallery. Groups look very messy and probably won't be implemented anytime soon. After I get a couple of more things cleaned up and remove some hard-coded paths, I'll have something for a few brave souls to try. I won't put a timeline on it though...
- Andy
why does gus break my glmenu when I activate the user stats option - expected ')',
[/QUOTE]
I'm not sure what you mean here - are you talking about the $_GUS_user option in the config.php file? What so you mean by 'glmenu'?
[QUOTE BY= suprsidr]
and I get this error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE ID = '1' LIMIT 1' at line 1. SQL in question: SELECT OuterFrame FROM WHERE ID = '1' LIMIT 1
when I manually go to gus/index.php
[/QUOTE]
Do you have the $_GUS_phplinks option set to 1? I inherited that from the stats plugin, but have never tested it because I don't have phplinks installed. In fact, I don't even know what phplinks is :-)
[QUOTE BY= suprsidr]
Also how's the G2 integration going?
[/QUOTE]
Slowly - real life is keeping me rather busy lately. I have a plugin which installs, maps the GL admin user to the G2 admin user, and creates G2 users on the fly whenever a GL user goes to the gallery. Groups look very messy and probably won't be implemented anytime soon. After I get a couple of more things cleaned up and remove some hard-coded paths, I'll have something for a few brave souls to try. I won't put a timeline on it though...
- Andy
GUS plugin problem
Posted on: 08/11/05 06:23am
By: suprsidr
Thanks, the phplinks to 0 fixed the index.php thing.
And by glmenu I mean the dhtml one that Blaine[*3] makes. I get a javascript error "expected')'" whenever I enable user stats function $_GUS_user=1.
I took a look at G2, but it is way beyond my skills. Not as easy as G1.
Keep up the good work.
And by glmenu I mean the dhtml one that Blaine[*3] makes. I get a javascript error "expected')'" whenever I enable user stats function $_GUS_user=1.
I took a look at G2, but it is way beyond my skills. Not as easy as G1.
Keep up the good work.
GUS plugin problem
Posted on: 08/11/05 10:16am
By: asmaloney
I don't have glmenu, but I suspect he's doing something fancy with the HTML which is produced for the admin menu via plugin code. GUS returns two links here instead of just one, which probably confuses it.
If you want to 'just get it working', then try this:
1) Find line 332 in functions.php]:
2) Remove it.
If you want a more permanent solution, then you'll have to contact Blaine. If he can't do it at his end, maybe we can work together to come up with a solution.
- Andy
If you want to 'just get it working', then try this:
1) Find line 332 in functions.php]:
$title .= '</a> <a href="' . $_CONF['site_url'] . '/gus/day.php' . '">[' . $LANG_GUS_blocks['today'] . ']';
2) Remove it.
If you want a more permanent solution, then you'll have to contact Blaine. If he can't do it at his end, maybe we can work together to come up with a solution.
- Andy