After some extensive work on the database sorting links into the right categories when i regenerate counters i get the error below. Although the counters do seem to update OK.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a1golfco/public_html/databases/mysql.php on line 19
Also, after the extensive database sorting I see that somehow the categories pages have become corrupted (even though nothing was changed and work was only done in MySQL) See below for example.
I hope you can shed some light on this as i have several more similar sites that I need to perform the same process on. I am guessing that the script does not like categories being created and deleted in MySQL
In the linked category, you appear to have set it to some very large number of columns per row -- either in the general setting or the specific-to-category setting.
Thanks. I fixed the first bit - it was just a typo
The MySQL bit. I read the page on that. It's obviously something that we did through the database and not the script. Everything appears to be working OK at the moment. Should I leave it and see what happens?
To get the debug of a dynamic page like this you need to set the debug level to "show all queries to admin" at Admin -> Settings -> System, then go to the regeneration and pause it. Or you can send me an admin login and I'll have a look at it.
2 at a time seems problematic, I've never had to go that low. Not sure what would be using the extra memory or if the server has an issue. If you have control of the server you could try restarting it like the message suggests.
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on Problem when regenerating
Forum Regular
Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 32
Total Comments: 130
Hi,
After some extensive work on the database sorting links into the right categories when i regenerate counters i get the error below. Although the counters do seem to update OK.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a1golfco/public_html/databases/mysql.php on line 19
Also, after the extensive database sorting I see that somehow the categories pages have become corrupted (even though nothing was changed and work was only done in MySQL) See below for example.
http://www.a1-golfcourses.co.uk/surrey-golf-courses/
I hope you can shed some light on this as i have several more similar sites that I need to perform the same process on. I am guessing that the script does not like categories being created and deleted in MySQL
Thanks
Jez.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
In the linked category, you appear to have set it to some very large number of columns per row -- either in the general setting or the specific-to-category setting.
For mysql warnings, see scripts.webmastersite.net/w...icles/mysql-errors-66.html
Forum Regular
Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 32
Total Comments: 130
Paul,
Thanks. I fixed the first bit - it was just a typo
The MySQL bit. I read the page on that. It's obviously something that we did through the database and not the script. Everything appears to be working OK at the moment. Should I leave it and see what happens?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Whatever the cause, if it results in a mysql warning then the debug info should show why.
Forum Regular
Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 32
Total Comments: 130
Paul,
I attach the debug info.
Thanks,
Jez.
Attached Files:
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
There are no mysql warnings in the file you attached.
Forum Regular
Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 32
Total Comments: 130
That's strange. I get the errors when I regen the counters etc.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Maybe you didn't stop the page from reloading before you copied it?
Forum Regular
Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 32
Total Comments: 130
Paul,
I am not sure if this is the correct info either.
I stopped the reload when I got the errors and pasted ?debug=1 after the url
(http://www.abc-directory.co.uk/admin/index.php?de...)
Is that the right way to do it or have I misunderstood the manual?
Thanks,
Jez.
Attached Files:
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
To get the debug of a dynamic page like this you need to set the debug level to "show all queries to admin" at Admin -> Settings -> System, then go to the regeneration and pause it. Or you can send me an admin login and I'll have a look at it.
Forum Regular
Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 32
Total Comments: 130
Hi Paul,
Thanks for the explaination and the offer. If this isn't correct I will PM you the login info.
Jez.
Attached Files:
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
That's it. The error is this part:
Number of rows is Out of memory; restart server and try again (needed 65528 bytes)
Load time so far: 61.27 seconds.
Out of memory; restart server and try again (needed 65528 bytes)
This must mean the server can't handle doing that many items at a time, it runs out of memory. You'll need to specify fewer.
Forum Regular
Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 32
Total Comments: 130
Thanks paul. I had to take it right down to 2! But no errors so that's good.
Did you get my email BTW?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Yes, I'll reply to the email shortly.
2 at a time seems problematic, I've never had to go that low. Not sure what would be using the extra memory or if the server has an issue. If you have control of the server you could try restarting it like the message suggests.