migrating between two servers issues

[rycardo74]

hi Im found a bug in indexu when you move the directory between two servers the table/column idx_link_temp.spam don't set
to 0 the new links automatically you have to run this query:

ALTER TABLE 'milano'.'idx_link_temp' MODIFY COLUMN 'spam' CHAR(1) CHARACTER SET latin1 NOT NULL DEFAULT 0;

and all is fine , remember purge the table for broken links.


http://assistenza.milano.it
http://www.auyama.it

[Bruceper]

If you copied the database this wouldn't happen unless the issue already existed.

And please users, do NOT blindly copy the query above. You MUST replace 'milano' with your own table name or all you will recieve are errors. You may also need to change the CHARACTER SET.

Also note that this issue has come up before. It must be the way some servers are configured that this table isn't being set correctly (possibly set to null?)

[Bruceper]

This command works without issues and without having to modify anything for a specific character set or database

ALTER TABLE `idx_link_temp` CHANGE `spam` `spam` CHAR( 1 ) NOT NULL DEFAULT '0'

And as a precautionary note - users should NEVER run queries in mysql unless they know EXACTLY what the query does and they have a full verified functional backup saved in two locations! You have been warned, running a query incorrectly can explode your database and render your site useless, there is NO undo function in phpmyadmin.

[inspireme]

or you could use the find and replace from the admin panel.