Geeklog Forums

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

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 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 the latest version, it is much more refined.

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

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.

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

Tnx Andy!

Changing in functions.inc worked, the site are now back to normal

Great! I'll see if I can find a better solution for this...

- Andy

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

Silly me, deleting the stuff I found just now. This was too obvious for me!
...

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

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

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

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

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

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

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

---

FlashYourWeb and Your Gallery with the E2 XML Media Player for Gallery2 - http://www.flashyourweb.com

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'?


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 :-)


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

Thanks, the phplinks to 0 fixed the index.php thing.

And by glmenu I mean the dhtml one that Blaine 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.

---

FlashYourWeb and Your Gallery with the E2 XML Media Player for Gallery2 - http://www.flashyourweb.com

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