Breaking serendipity with creative ways...
Posted: Tue Jul 27, 2004 10:55 am
![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)
We moved my wife's blog from old server to new one and upgraded from some 0.5 version to 0.6pl3. Now some readers complain that the text doesn't wrap correctly on IE or on Opera and they have to scroll horizontally to get it read. According to same sources this doesn't happen on my installation or on peikko's installation. Any ideas? My wife swears that she has not touched any files other than templates/default/style.css which I gave her fresh copy from my installation and it did not help. As I see it there are two explanations:
She has edited something else that breaks things and does not remember doing it or
the content of her blog and layout somehow breaks the IE and Opera in ways that don't happen on our other two blogs.
Any suggestions where to start to fix it?
I have broken my installation somehow. The plugin configuration screen no longer shows event plugins select at all. This is an error condition that is somehow related to the contents of the database. I tried doing fresh install from cvs and just copying uploads- and serendipity_config_local.inc.php from the old install to new one and it exhibits the same problem.
If I create a new database I get to see the event plugins select.
Then I tried to work around this by exporting/importing the entries from the old database to the new one but the import in the 200407261337 seems to be broken with postgresql. It just generates a bunch of syntax errors.
I also tried upgrading but it just results a blog that spews selects with missing attributes.
As I see it I have four viable options to fix this
1) Find out what it is in the database that breaks the plugins and fix it manually. Is there any documentation about database structure/tables I could use to get better grasp of the meanings of the tables and attributes?
2) Read the database upgrade scripts and try fix what causes the missing attributes and hope that this fixes the plugins' problem at the same time
3) Do a new installation of 0.6pl3 from scratch to a new database. Manually create all categories. Import entries from the old database. Copy uploads from the old directory to the new one. Remove old directory. Move new directory to the old directory. Try to fix what is broken in configuration because of the wrong path.
4) Create a new database manually. Create a export script that exports necessary items from the old database to a file and modifies filepaths on the fly if necessary. Create an import script that imports these necessary items from the file to the new database.
Any suggestions?