DB issue after converting

[HunterP]

Ok, tried it again :

#1050 - Table 'temp_subjects' already exists

But now it seems to work??

How can I remove this temp table?

[ziycon]

The below query should remove it. Due to it being created using the 'CREATE TEMPORARY TABLE' syntax it should automatically be dropped after your queries have run, strange.

Code Select Expand

DROP TABLE temp_subjects;

[HunterP]

The below query should remove it. Due to it being created using the 'CREATE TEMPORARY TABLE' syntax it should automatically be dropped after your queries have run, strange.

Code Select Expand

DROP TABLE temp_subjects;

Already tried that :

#1051 - Unknown table 'temp_subjects'

[ziycon]

I was half asleep when I replied this morning, it should be the below query as its a temporary table.

Code Select Expand

DROP TEMPORARY TABLE temp_subjects;

[HunterP]

I was half asleep when I replied this morning, it should be the below query as its a temporary table.

Code Select Expand

DROP TEMPORARY TABLE temp_subjects;

Also tried that one before, same error :

#1051 - Unknown table 'temp_subjects'

[ziycon]

Are you sure the tables even there? it should drop straight after the query has ran!?

[HunterP]

Are you sure the tables even there? it should drop straight after the query has ran!?

No I'm not sure, but the second time I tried to ran the query, SQL said that the table already existed, but maybe something went wrong the first time, and the second time it was deleted?

Thanks anyway

[ziycon]

Ok, no problem, is your forum working ok now?

[HunterP]

Ok, no problem, is your forum working ok now?

Perfectly, thanks!