MCCodes V2 Installation problem

[hellgirl]

Hello There.

I'm currently on the 3rd step on the installer (Installation and Extras) for MCcodes v2.

Here's what it says. Please help me out on what to do now.

Write Config...

Config written.

Attempting DB connection

Connection Successful.

Writing Main MySQL data.

QUERY ERROR: Table 'applications' already exists

Query was CREATE TABLE `applications` ( `appID` int(11) NOT NULL auto_increment, `appUSER` int(11) NOT NULL default '0', `appGANG` int(11) NOT NULL default '0', `appTEXT` text NOT NULL, PRIMARY KEY (`appID`)) ENGINE=MyISAM ;

[Danny696]

Re: MCCodes V2 Installation problem

 

Table 'applications' already exists

read it slowly then you may find out

[hellgirl]

Re: MCCodes V2 Installation problem

yeah, thanks for the notice. But i did read it slowly, I'm a goddamn noob and don't know what to do with all this.

[Danny696]

Re: MCCodes V2 Installation problem

sorry i just find it hard to belive that theres like 20 posts on here saying the same thing you need to go to phpmyadmin and delete the table called aplications if youve allready set up all the tables just find in installer

$fo=fopen("dbdata.sql","r");

and replace with

$fo=fopen("","r");//dbdata.sql - So you know what the file is 

[hellgirl]

Re: MCCodes V2 Installation problem

ok, i'll give it a try. but it just changed to this mate.

Write Config...

Config written.

Attempting DB connection

Connection Successful.

Writing Main MySQL data.

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 ;

Do you happen to have msn to help me out?

[Nicholas]

Re: MCCodes V2 Installation problem

i had the same problem, if i deleted the applications from phpmyadmin database thing, i got the same message but with announcements.

if i remember correctly i exported the sql files and saved them on my desktop, then i deleted all the databases, and then i used the installer.php again and it worked, i saved the cron job information i got at the bottom of the page onto a notepad and saved that onto my desktop as u will need it, then i imported the sql file you saved on phpmyadmin to create all the databases again. and logged on.

sorry if its confusing, i hope it works and helps.

[Danny696]

Re: MCCodes V2 Installation problem

did you delete the applications table? if you did go check if its there or not it may have been added and if it is do the second thing i said. Add me on [email protected]

[hellgirl]

Re: MCCodes V2 Installation problem

:evil:

I am using .ej.am as my webhost and it does work for mccodes for sure. It has millions. So on my phpadmin, I dropped my applications table, then the code went back to the annoucement set up.

What is the control + whatever thing to search for words on a internet explorer webpage? I want to do it to find what i need to replace.

[Danny696]

Re: MCCodes V2 Installation problem

CTRL + F

[hellgirl]

Re: MCCodes V2 Installation problem

Write Config...

Config written.

Attempting DB connection

Connection Successful.

Writing Main MySQL data.

Warning: fopen() [function.fopen]: Filename cannot be empty in /home/currican/public_html/installer.php on line 468

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

Warning: fclose(): supplied argument is not a valid stream resource in /home/currican/public_html/installer.php on line 471

Main MySQL data was written.

Now write Extra MySQL data.

QUERY ERROR: Unknown column 'donatordays' 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( 'admin', 'admin', md5('fdsfds'), 1, 100, 0, 0, 2, 12, 12, 100, 100, 5, 5, 100, 100, 1, '', unix_timestamp(), '[email protected]', -1, '125.25.21.205', '125.25.21.205')

 

This is what comes up now. After replacing what you told me to with $fo=fopen("","r");

Is that right?

[Nicholas]

Re: MCCodes V2 Installation problem

have u tried my way yet?

[hellgirl]

Re: MCCodes V2 Installation problem

Mate.

With your steps.

Please list all steps, step by step.

But, I have this now. so what do I do?

[Nicholas]

Re: MCCodes V2 Installation problem

ok let me try and say it in a list on how i done it. not sure if it work tho, but its worth a try i guess

1. backup your dbdata.sql file and save it on your desktop

2. select your whole database and drop it

3. go to www.yourgamename.???/installer.php

4. make sure you acturally have set up mysql database up and have put the information in the config.php file, there should be 11 lines down on your config.php file.

5. put the information in your installer.php bit, that the config.php file information has, and click submit when thats done, and hopefully your game should install.

6. if it installs at the bottom u see some coding for the cron jobs they should look like this

*/5 * * * * curl [url]http://yourgamename.???/cron_fivemins.php?code=numbers[/url] and letters

there should be like 4 of them, copy them all and save them onto a notepad or whatever you have and save that information on your desktop or where ever you want.

7. log into your game and see if it works, then if it does go into your public_html folder and delete installer.php so no one can use it and make a admin account if they know your config.php file details.

8. then go onto your phpmyadmin and import the dbdata.sql file on your desktop or whereever you saved it.

9. then you should be all set up.

hopefully ive said everything i done.

[Danny696]

Re: MCCodes V2 Installation problem

ROLFLMAO thats one long way of doing it

[Nicholas]

Re: MCCodes V2 Installation problem

but if it works, wouldnt it be worth it?

[h4llw4lk3r]

Re: MCCodes V2 Installation problem

Basically, the applications table in your SQL database is already there, this might have been due to a previous install of MC2 codes or another application maybe, but you need to delete this before continuing.

[Danny696]

Re: MCCodes V2 Installation problem

h4llw4lk3r can you be any later :evil:

[meltdown2k9]

Re: MCCodes V2 Installation problem

go on php my admin scroll down select all fields , in the dropdown ( to the right ) click drop , then install

done :)

[wolfe]

Re: MCCodes V2 Installation problem

Like watching a trainwreck.

[Danny696]

Re: MCCodes V2 Installation problem

 

go on php my admin scroll down select all fields , in the dropdown ( to the right ) click drop , then install

done :)

Now your just adding insult to injury arent you weve done it like 4 times and told hellgirl 4 different ways then the next you you just say a random one. Lol very tru wolfe

[Nicholas]

Re: MCCodes V2 Installation problem

 

go on php my admin scroll down select all fields , in the dropdown ( to the right ) click drop , then install

done :)

thats techincally what i said...