Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Getting paging errors

Quote Reply
Getting paging errors
I am getting errors with the page count (1 2 3 4 ... 56) part of GForum. On any page that supports page navigation like forum view, post view---even PM message list or PM view, the page count is over 6 million pages Shocked! The numbers are different for every view. I changed the look of this on the templates a long time ago (fonts & colors only), but this started happening a day or two ago.

Anyone run into this yet? Any ideas what's going on?

Dave
Quote Reply
Re: [bretzke] Getting paging errors In reply to
I did run into this recently, but only with a newer version of the Template parser that - as far as I know - hasn't gone out with anything. I've got a fixed copy of GForum/GUI.pm, which I've attached - let me know if it fixes the problem.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Quote Reply
Re: [Jagerman] Getting paging errors In reply to
That did the trick! Thanks Jason! Cool

Dave
Quote Reply
Re: [Jagerman] Getting paging errors In reply to
Should everyone use the new GUI.pm or only if we face problems?

Klaus

http://www.ameinfo.com
Quote Reply
Re: [klauslovgreen] Getting paging errors In reply to
Nope, it isn't required - nothing we have released yet has included the new GT::Template version; he was running some customized, beta code that had new modules installed a couple of days ago.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Quote Reply
Re: [Jagerman] Getting paging errors In reply to
Was it GList that screwed this up?

Dave....wondering if I'll find more presents lying around....Wink
Quote Reply
Re: [Jagerman] Getting paging errors In reply to
I was editing a post I made last night and got this error...

A fatal error has occurred:
Unable to update record: Failed to execute query: 'UPDATE gforum_Post SET post_message = ? ,
post_last_edit_username = ? , post_reply_notify = ? , post_last_edit_time = ? , post_subject = ? ,
post_style = ? , post_icon IS ? WHERE post_id = ?' Reason: 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
'IS NULL WHERE post_id = '2446'' at line 1 at /home/dodrxnet/dodrxnet.org/perl/gforum/admin/GForum/Post/Write.pm line 1125.




Please enable debugging in setup for more details.

Is this a MySQL 4 thing?



Got another one while editing profiles from the Admin Panel:

Failed to execute query: 'UPDATE gforum_User SET user_title = ? , user_username = ? , user_val_code = ? , user_cols = ? , user_default_mh_user = ? , user_occupation_other = ? , user_email = ? , user_message_notify = ? , user_temp_pass IS ? , user_icon = ? , user_hidden_cats = ? , user_time_offset = ? , user_default_reply_notify = ? , user_signature = ? , user_advanced_editor = ? , user_default_mh_message = ? , user_state = ? , user_default_post_style = ? , user_location_other = ? , user_quick1 = ? , user_quick2 = ? , user_last_seen = ? , user_quick3 = ? , user_template = ? , user_mil_status = ? , user_homepage = ? , user_forum_view = ? , user_default_post_display = ? , user_disp_email = ? , user_jump_to_unread = ? , user_admin_validated = ? , user_real_name = ? , user_interests = ? , user_default_mh_flatpost = ? , user_rows = ? , user_status = ? , user_justify = ? , user_enabled = ? , user_show_user_icons = ? , user_do_after_post = ? , user_default_mh_forum = ? , user_location = ? , user_grade = ? , user_paygrade = ? , user_accept_privmsg = ? , user_invisible = ? , user_default_message_style = ? , user_default_mh_search = ? , user_occupation = ? , user_posts = ? WHERE user_id = ?' Reason: 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 'IS NULL , user_icon = '' , user_hidden_cats = '' , user_time_of



Dave

Last edited by:

bretzke: Apr 25, 2003, 5:06 AM
Quote Reply
Re: [bretzke] Getting paging errors In reply to
More of the same UPDATE errors. I had a couple of users trying to change their password and getting:

Failed to execute query: 'UPDATE gforum_User SET user_location_other IS ? , user_quick1 IS ? , user_quick2 IS ? , user_quick3 IS ? , user_mil_status = ? , user_occupation_other IS ? , user_email = ? , user_password = ? , user_message_notify = ? , user_real_name = ? , user_signature IS ? , user_default_reply_notify = ? , user_grade = ? , user_location = ? , user_accept_privmsg = ? , user_invisible = ? , user_state = ? , user_occupation = ? WHERE user_id = ?' Reason: 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 'IS NULL , user_quick1 IS NULL , user_quick2 IS NULL , user_quic


Help!

Dave
Quote Reply
Re: [bretzke] Getting paging errors In reply to
Apprently the beta libraries strike again! Thanks GT for finding & fixing the problem.

Dave