Error in forum when posting as a guest

morpheus_75 · Involved Joined: Oct 07, 2003 Posts: 302

This is the error:

*****************

Error in posting

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ' '', 1065607972, '3e657ed8', 0, 0, 0, 0)' at line 1

INSERT INTO nuke_bbposts (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig) VALUES (3, 1, , '', 1065607972, '3e657ed8', 0, 0, 0, 0)

Line : 310
File : D:\Inetpub\webs\whatisthematrixit\portale\includes\functions_post.php

*****************

On NukeCops I've found this fix:

In phpMyAdmin's sql query window write:

Code:

REPAIR table nuke_bbposts_text;

X RAVEN: Do u think it wil work? Is there another way to fix the prob? As I'm quite new to PHP and SQL, I'm always skeptical in handling the db...

Raven · Posted: Wed Oct 08, 2003 4:26 am

That command will not hurt anything. It may or may not be the solution. Try it - it won't hurt anything! Post back and let us know.

morpheus_75 · Involved Joined: Oct 07, 2003 Posts: 302

Raven wrote:

That command will not hurt anything. It may or may not be the solution. Try it - it won't hurt anything! Post back and let us know.

OK!

morpheus_75 · Involved Joined: Oct 07, 2003 Posts: 302

It seems it won't work... anyone has the fix for this?
TNX

Raven · Posted: Wed Oct 08, 2003 3:05 pm

I'm trying to find an answer on this. It's been a long time bug, but we'll keep looking.

morpheus_75 · Involved Joined: Oct 07, 2003 Posts: 302

Thanx!

chatserv · Posted: Thu Oct 09, 2003 7:19 am

I have seen this one before, the repair option is usually suggested when someone gets an error message that includes the term MYI, the time i saw a similar error was when someone had made a post with a poll, he had set it so that anyone could read the post but only registered users could vote so when a guest tried to vote it resulted in an error because the code tried to insert a user_id (blank in your error message) which logically doesn't exist because guests are not assigned a user_id other than -1 or 1 which is not allowed to access sections meant for registered users, let me know what it is you are trying to do (post, edit a post, vote in a poll) when you get the error.

morpheus_75 · Involved Joined: Oct 07, 2003 Posts: 302

The problem is solved. Only registered users can post... it's the only way to fix this, I think Wink

Now my problems are with the avatar and with the profile update. When i try to upload it, the forum does not display anymore. Or at least I see only the header, the menu bar, the name of the forum and... "information". No more... Shocked