Error in functions_search.php due to nfo update in sql....

[Hatz]

Could not insert new word

DEBUG MODE

INSERT IGNORE INTO phpbb_auto_search_wordlist (word_text, word_common) VALUES ('sdfdsaf', 0)

Line : 234
File : functions_search.php


Didnt edit any php files.....and im getting this all of a sudden when trying to post.....anyone else getting this, or know how to fix it?

[BnD|Sleeper]

Could not insert new word

DEBUG MODE

INSERT IGNORE INTO phpbb_auto_search_wordlist (word_text, word_common) VALUES ('sdfdsaf', 0)

Line : 234
File : functions_search.php


Didnt edit any php files.....and im getting this all of a sudden when trying to post.....anyone else getting this, or know how to fix it?

I suggest downloading the PHP forums again and take the file functions_search.php. Upload that file to it's respective directory (such as /includes/functions_search.php) as it seems to be having a problem with SQL.

Try to look things up on the Internet! before posting here asking questions, just put the error into a search engine and you'll probably get an answer. Or better yet, go to the PHPBB forums site and ask them!

Sleeper

[Hatz]

Try to look things up on the Internet! before posting here asking questions

You really think I'm that guy....

Sleeper you've been very helpful with questions ive had before, but that plain pissed me off....don't presume me to be an idiot and come off with a smartass comment like this. I thought it to be obvious that i have searched the problem.....which is where i found that it is indeed a sql issue and i did nothing to my sql....next time ill make clear that i searched...with quotes around it....before asking for help. Ill go to phpbbhacks for the answer.

[Edge100x]

Please email us at rentals@nuclearfallout.net about this, since it's probably a database issue related to the upgrade to MySQL 5.0. So far we have a 100% success rate of fixing bizarre issues like this .

[BnD|Sleeper]

Try to look things up on the Internet! before posting here asking questions

You really think I'm that guy....

Sleeper you've been very helpful with questions ive had before, but that plain pissed me off....don't presume me to be an idiot and come off with a smartass comment like this. I thought it to be obvious that i have searched the problem.....which is where i found that it is indeed a sql issue and i did nothing to my sql....next time ill make clear that i searched...with quotes around it....before asking for help. Ill go to phpbbhacks for the answer.

It was meant to be a "RTFM" moment because I felt that you had not searched for the answer on the internet. It had not dawned on me that the new MySQL update might have done that but John (Edge100x) has a point; it probably is related to the recent upgrade. No mean to be offensive with my post, girlfriend was rushing me to get to dinner if I remember correctly. Anyways, I did give you advice on fixing it so at least I was giving some advice at the same time .

Sleeper @ bndclan.com

[Hatz]

yes it is sql related and i fixed it with a repair to the base....however i just found a new error and it's almost worse, with usercp_register...and it's a sql error much like this previous one, only the magical repair db button doesnt work on this one....help.....

Could not insert data into users table

DEBUG MODE

INSERT INTO phpbb_auto_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_rankset_id, user_dateformat, user_lang, user_style, user_klass, user_level, user_allow_pm, user_active, user_actkey) VALUES (169, 'asdfasfd', 1194771754, '8c08b75637f1131319a3260edee74191', 'adfafdas@hotmail.com', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 1, 1, 1, 0, 1, 1, 0, 1, 'D M d, Y g:i a', 'english', 3, 0, 1, '0' 1, '')

Line : 993
File : usercp_register.php

[Edge100x]

There's an error in the syntax of that insertion. It's right at the end -- your script is leaving out a comma.

1, '0' 1, '')

should read

1, '0', 1, '')

That means that there is a bug in your script

[Hatz]

ya i fixed it, nick sent me that before sorry i thought i posted that it was solved. Thanks for the help though