Need some help!!!

[william7neace]

i fell pretty stupid right now.... i got this after i filled in the info d=for the installer.php---->>>>

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 ;

how do i fix??? ?( ?(

 

[Dominion]

i fell pretty stupid right now.... i got this after i filled in the info d=for the installer.php---->>>>

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 ;

how do i fix??? ?( ?(

 

They already exist so delete them. I assume this is due to a failed run of the installer.php before hand...

[Kieran-R]

the table announcements already exists. So delete it.

"QUERY ERROR: Table 'announcements' already exists"

Common sense really. Isnt it?

[william7neace]

I delete the announcements.php totally and i still have it

[Dominion]

I delete the announcements.php totally and i still have it

Don't clear one table that the installer created, clear them ALL and then run again. That is as long as there’s nothing you need to backup. since this is your 1st install that should not be an issue.

[william7neace]

Did as you said got this

 

Installer

1. Diagnostics >> 2. Configuration >> 3. Installation & Extras

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=

[Dominion]

If the table exists you did not delete it...

[Kieran-R]

delete the table announcements. Not the file.

[william7neace]

This is my coding for announcements ----------------------------------->

 

<?php

include "globals.php";

$ac=$ir['new_announcements'];

$q=$db->query("SELECT * FROM announcements ORDER BY a_time DESC");

print "<table width='80%' cellspacing='1' class='table'>

<tr>

<th>Time</th>

<th>Announcement</th>

</tr>";

while($r=$db->fetch_row($q))

{

if($ac > 0)

{

$ac--;

$new="

New!";

}

else

{

$new="";

}

print "<tr><td valign=top>".date('F j Y, g:i:s a', $r['a_time']).$new."</td><td valign=top>{$r['a_text']}</td></tr>";

}

print "</table>";

if($ir['new_announcements'])

{

$db->query("UPDATE users SET new_announcements=0 WHERE userid={$userid}");

}

$h->endpage();

?>

[Danny696]

There is nothing wrong witht the code, its the database.

[Dominion]

It's not about the file...

Go into phpmyadmin and delete the tables that were made by the first run of the installer.php, the one that failed on settings.

[william7neace]

The web service i use doesn't have phpmyadmin. It has SQL buddy

[Dominion]

The web service i use doesn't have phpmyadmin. It has SQL buddy

Whatever program you're using to deal with your database then, the point is the same...

[william7neace]

Well I can't figure it out.... Should i just make a new Db and DB user???

[Dominion]

Well I can't figure it out.... Should i just make a new Db and DB user???

I am going to say go and read some tutorials.Even if it's just learning how to drop a table http://www.w3schools.com/sql/sql_drop.asp

[Danny696]

No, go to your database, and delete every table. Re-install.

[william7neace]

So should i just drop them all then run installer again???

 

Export

Tables:

All / None

Export: Structure

Data

Options: Compact inserts

Complete inserts

If you are exporting a large number of rows, it is recommended that you output the results to a text file.

Output to: Browser

Text file:

[Danny696]

Just drop them and run the installer again, no need to export

[william7neace]

got it all set but my cpanel doesn't have cron jobs.... how can i get them to work without it????

[Danny696]

Use timestamps, search may bring up some results

[william7neace]

well i am looking on google.... What should i look for???

[Kieran-R]

not being a dick or anything, but you have no idea even how to drop a dbtable, and can't tell the difference between a php file, and a db table, yet you are trying to build a game?

I suggest you go learn more about PHP, and MySQL before you start trying to build a game.

Here's a good site: w3schools.com

[Dominion]

@Kieran-R - Not as if you have not asked for help before, and he is in fact putting time into reading a fair few pages that people gave him in chat so it's not like he is not trying at this point. Everyone starts somewhere.

[Kieran-R]

Yea I know, and I give him full credit for that. But I'm just advising him, to at least get a grasp of PHP, and MySQL before jumping into building a game.

[Dave]

Dude if you need help PM me...

This guy reminds me of how I used to be.. Check my old posts and you'll see.