Database error

[filoujr]

Hi,

I tried to change my database structure lately, i got this error :

requête SQL:
ALTER TABLE `tablename` DROP `number`
MySQL a répondu:
#1025 - Error on rename of './filoujr_database/#sql-74c2_2d4812' to './filoujr_database/tablename' (errno: 150)

if i try to add a new tablerow and delete it, it works.
If i try to delete an old one (child row) it doesn't work.

it looks like if my table has a different name.

Thanks

 

[papichulo_carioco]

What I would do is:
1 .- backup of the database and files on your page
2 .- delete the old database completely.
3 .- build another database with the prefix and install the cms that you use from scratch and
4 .- then import the data from the old database and upload the files guarded, less the "config.php". Greetings

 

[filoujr]

I tried it, it works, thank you very much!

This thread can be closed.

 

[Anna]

*thread closed*