Page 1 of 1
staticpages 3.83 case 18 failed
Posted: Sun Apr 03, 2011 6:23 pm
by Timbalu
I just updated from 3.80 to 3.83 but the $sql = 'ALTER TABLE '.$serendipity['dbPrefix'].'staticpages ADD COLUMN is_404_page int(1) default 0'; did not add the column.
I noticed this by updating an old entry.
$this->set_config('db_built' jumps from 7 to 19 ... where are the set_configs inbetween?
I just remembered once having problems with the install of the additional staticpages tables too.
Maybe there is a major problem in the db update logic...
Re: staticpages 3.83 case 18 failed
Posted: Sun Apr 03, 2011 10:47 pm
by garvinhicking
Hi!
There are no in-betweens, they were removed on each plugin update. It's okay to jump to 19.
I suppose the SQL query failed for you. You might want to edit your serendipity_config entry for the db_built to reset it to 7, then edit the staticpage event file to maybe log the output of mysql_error() after each serendipity_db_schema_import. Maybe your MySQL is older and chokes one a statement? Not all of them were done and checked by me, it could very well be that there's a bug in one of them.
In mysql(i) a "AFTER ..." is appended to the SQL, maybe that could be your issue?
Regards,
Garvin
Re: staticpages 3.83 case 18 failed
Posted: Mon Apr 04, 2011 9:14 am
by Timbalu
Thank you Garvin.
garvinhicking wrote:I suppose the SQL query failed for you.
In mysql(i) a "AFTER ..." is appended to the SQL, maybe that could be your issue?
Well its a pure debian Lenny system. Pure PHP and MySql in some 5.x versions. I did already solve that little issue by adding it manually, but looking into the code, I couldn't find any reason why it failed (at least here, sometimes). This must be some kind of special case, else a lot of people would complain about it here in the forum. So my thread was more a kind of notice.