Topic: Database User + Post

Is it possible to user a clean data base from the db management and add users and post to that database from wordpad. If so how could I do it because I tried and I got an error saying; Unable to fetch guest information. The table 'users' must contain an entry with id = 1 that represents anonymous users.

[img]http://img90.imageshack.us/img90/746/scripter8ko.png[/img]
http://openwings.co.cc

Re: Database User + Post

You deleted the Guest user.

Re: Database User + Post

Nope the guest is still there:

INSERT INTO users (id, group_id, username, password, email, title, realname, url, jabber, icq, msn, aim, yahoo, location, use_avatar, signature, disp_topics, disp_posts, email_setting, save_pass, notify_with_post, show_smilies, show_img, show_img_sig, show_avatars, show_sig, timezone, language, style, num_posts, last_post, registered, registration_ip, last_visit, admin_note, activate_string, activate_key, num_posts_chatbox, last_post_chatbox, rep_minus, rep_plus, reputation_enable, reputation_enable_adm) VALUES('1', '3', 'Guest', 'Guest', 'Guest', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, '1', '1', '0', '1', '1', '1', '1', '1', '0', 'English', 'Oxygen', '0', NULL, '0', '0.0.0.0', '0', NULL, NULL, NULL, '0', NULL, '0', '0', '1194272699', '1', '1');

[img]http://img90.imageshack.us/img90/746/scripter8ko.png[/img]
http://openwings.co.cc

Re: Database User + Post

Not in the actual database, maybe in your dump. Otherwise that error messages wouldn't happen.

Re: Database User + Post

Smartys wrote:

Not in the actual database, maybe in your dump. Otherwise that error messages wouldn't happen.

I've deleted the new guest database for the old one thats all I did. In the actual database, I didn't touch anything but I'll go check. What do I have to find and what do I have to do. I really suck with manging database. I'm here cause I want to learn.

[img]http://img90.imageshack.us/img90/746/scripter8ko.png[/img]
http://openwings.co.cc

Re: Database User + Post

Don't delete the guest user. The error you got indicated that you deleted the guest user.

Re: Database User + Post

Smartys wrote:

Don't delete the guest user. The error you got indicated that you deleted the guest user.

Okay I'm so lost, can you give me an example?

[img]http://img90.imageshack.us/img90/746/scripter8ko.png[/img]
http://openwings.co.cc

Re: Database User + Post

http://www.openwings.zephyrhosting.net/forum/

Re: Database User + Post

Right. That error means you deleted the guest user from your users table. Don't do that tongue
That's all I'm saying wink

Re: Database User + Post

How do I fix thst is what I'm asking.

[img]http://img90.imageshack.us/img90/746/scripter8ko.png[/img]
http://openwings.co.cc

Re: Database User + Post

Run that insert query you showed me earlier in the topic

Re: Database User + Post

Ah fuck it to complicated for me.

[img]http://img90.imageshack.us/img90/746/scripter8ko.png[/img]
http://openwings.co.cc