need some help? i dont get it?

[Nicholas]

Write Config...
Config written.
Attempting DB connection
Connection Successful.
Writing Main MySQL data.

Warning: fopen(dbdata.sql) [function.fopen]: failed to open stream: No such file or directory in /home/nicholas/public_html/installer.php on line 465

Warning: fread(): supplied argument is not a valid stream resource in /home/nicholas/public_html/installer.php on line 467

Warning: fclose(): supplied argument is not a valid stream resource in /home/nicholas/public_html/installer.php on line 468
Main MySQL data was written.
Now write Extra MySQL data.
QUERY ERROR: Unknown column 'lastip_signup' in 'field list'
Query was INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip, lastip_signup) VALUES( '*************', '************', md5('****************'), 1, 100, 0, 0, 2, 12, 12, 100, 100, 5, 5, 100, 100, 1, '', unix_timestamp(), '*******************', -1, '90.211.241.223', '90.211.241.223')

 

the stars are my information login stuff, dont wanna show people it lol, anyways can someone please tell me whats wrong here?

[Danny696]

Re: need some help? i dont get it?

in your users database there isnt a colom called lastip_signup look at dbdata.sql and find it in there and insert it after lastip Thanks Danny696

[Nicholas]

Re: need some help? i dont get it?

ill give it a look thx for telling me, hopefully it works.

[Nicholas]

Re: need some help? i dont get it?

it seems i do have the lastip_signup on users in phpmyadmin sql bit. can anyone please put up a working dbdata.sql file up here please? so i can acturally set my game up? it would be greatful.

[Nicholas]

Re: need some help? i dont get it?

QUERY ERROR: Table 'announcements' already exists

Query was CREATE TABLE `announcements` ( `a_text` text NOT NULL, `a_time` int(11) NOT NULL default '0') ENGINE=MyISAM ;

i get that query error why?

[Danny696]

Re: need some help? i dont get it?

 

ERROR: Table 'announcements' already exists

if you break it down all its saying is your trying to make a table thats allready there try

DROP TABLE `announcements`

then create the new table

[Nicholas]

Re: need some help? i dont get it?

ok but first, is this how you make new table for announcements?

ALTER TABLE `users` ADD `announcements` INT( 11 ) NOT NULL DEFAULT '0';

????

[wolfe]

Re: need some help? i dont get it?

no. thats adding a field called announcements to the users table.

[Faz`]

Re: need some help? i dont get it?

I think what you're most probably doing is running the installer file again.

If you are, delete your database, create a new empty one, and run the installer then.

[Nicholas]

Re: need some help? i dont get it?

what do u mean running the installer file again?

and which database your talking about? phpmyadmin or file manager?

 

oh and whats the alter table information to create a new table?

if anyone knows what i mean, can u write one for me for an example for say the announcements?

[Danny696]

Re: need some help? i dont get it?

 

what do u mean running the installer file again?

and which database your talking about? phpmyadmin or file manager?

 

oh and whats the alter table information to create a new table?

if anyone knows what i mean, can u write one for me for an example for say the announcements?

only one database and thats phpmyadmin if ya wanna create a new table why alter a table basic mysql is understandable by alot of newbies use karlos' annoucement there probabbly the best ones on here that doesnt even use the annocuements table and running the installer again is dropping all the database and runnning installer.php again

[Danny696]

Re: need some help? i dont get it?

http://criminalexistence.com/ceforums/i ... 49.0 thats karlos' annoucements

[wolfe]

Re: need some help? i dont get it?

If you take a few mins to learn some mysql basics, it will really help you a lot.

[Nicholas]

Re: need some help? i dont get it?

ahh fixed it i figured out why it was doing it. i just removed all my phpmyadmin database files, then installed my game, then readded the sql information on phpmyadmin.

[Danny696]

Re: need some help? i dont get it?

do what wolfe said and also learn PHP