vb.org Archive - Admin deleted causing erros database

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Admin deleted causing erros database (https://vborg.vbsupport.ru/showthread.php?t=309096)

Manoel J?nior

03-02-2014 11:34 PM

Admin deleted causing erros database

Deleted my administrator user, which I had done numerous posts on forum, unfortunately I was careful to protect myself in config.php and put my user as undeletableusers.

I created a new user with the same name I had, I went into my database and modified my group to be an administrator, right now I'm checking the logs to see which admin gave me this tragedy.

I would like you to help us, because whatever topic I go, where I had commented or even started posting gives SQL error as below:

Code:

Invalid SQL:

SELECT * FROM `thread` WHERE `postuserid`=;



MySQL 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 '' at line 1

I've tried to change my userid in the database to my old, who was the userid 1, but still did not work.

Could someone give me a hand as I could fix this error?

PS. Sorry my bad english.

Lynne

03-03-2014 12:13 AM

I'm not sure I understand what you did. If your user was set as undeleteable in the config.php file, how did you delete it?

If you created a new user and then changed the userid for the user to your old userid, did you make sure to change it in ALL the tables you needed to change it in? It isn't just the user table that uses the userid.

Max Taxable

03-03-2014 12:36 AM

Quote:

near '' at line 1

Sounds offhand like you have a extra " on line 1 where there's not supposed to be one. Or some character.

What program are you using to edit php files?

Manoel J?nior

03-12-2014 08:11 PM

Quote:

Originally Posted by Lynne (Post 2484663)

What are the tables? Well I changed my userid to the old and still continue with the same error.

Quote:

Originally Posted by Max Taxable (Post 2484669)

Sounds offhand like you have a extra " on line 1 where there's not supposed to be one. Or some character.

What program are you using to edit php files?

There is error in the file, this occurred because a user deleted my admin user: userid: 1

Lynne

03-13-2014 12:09 AM

user, userfield, usertextfield. Not to mention post, thread, attachment, visitormessage, etc. So many tables use the userid in them.

Max Taxable

03-13-2014 01:14 AM

I misunderstood the issue, carry on.

All times are GMT. The time now is 02:46 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01055 seconds Memory Usage 1,722KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: