News & Story count not same after import

Report bugs and errors in this forum.

News & Story count not same after import

Postby BadDog » Sun Dec 04, 2005 9:12 pm

If you import from cutenews (en) data to cutenews.ru using the update script you get different size record counts for news and story in mySQL. They should both match and not differ. Use phpMyAdmin to verify the records count for both tables after import.



Only work around I could come up with for this mismatch was to write a script to directly create a sql dump file from cutenews text files data and then import it to get both tables to match exactly.
BadDog
 
Posts: 62
Joined: Mon Nov 21, 2005 8:19 am

Postby BadDog » Mon Dec 05, 2005 1:33 am

I *think* what the problem is the size of the title and url fields in mySQL. they have a max length of 255 and when a url or title is too long (likely when using HTML in titles) the mySQL class is ignoring the error and skipping, leaving the final index a wreck!
BadDog
 
Posts: 62
Joined: Mon Nov 21, 2005 8:19 am


Return to Bugs and errors



Who is online

Users browsing this forum: No registered users and 0 guests

cron