hi all

i decided to upgrade my weblog from pM 2.2.1 to 2.4. the upgrading process went fine and produced no troubles. but unfortunately some things went wrong afterwards, when i tried to use the updated version of pMachine.

- my main weblog page shows no entries at all, but instead, when i turn debugging on, it states:

MySQL Error: 1054  Unknown column ‘sticky’ in ‘order clause’
Query: select *, GREATEST(c_date, t_stamp) AS cw_date from pm_weblog where weblog = ‘weblog’ and status = ‘open’ and preview != ‘1’ and t_stamp <= ‘1156505108’ and x_stamp >= ‘1156505108’ order by sticky DESC, t_stamp desc limit 0, 15

and

Notice: Undefined variable: secure_forms in lib/search.fns.php on line 50

- categories on the weblog main page are shown, but they have no connection to my former categorized entries.
- i am not able to fully use “new entry” in my control panel, when i try to save a new entry, the last one i edited in 2.2.1 shows up, but no new entry is saved. so i guess something is wrong with mysql.

what can i do? any ideas?
thanks for your help,

eva_susa

It sounds like your upgrade didn’t work completely.

sticky is a field added in 2.4.

sticky, sent_pings, trackback_ip, status in pm_weblog and status and comment_ip in pm_comments were what changed.

You’d need to add these by hand using something like phpMyAdmin.

thanks sue. first problems solved. my entries on my main weblog page are back!

but there are still some bugs stated:

- there is still the statement
Notice: Undefined variable: secure_forms in lib/search.fns.php on line 50

- it seems that a whole table is missing. at the bottom of the “new entry” page as well on the ping servers page in the control panel i got the following error:
MySQL Error: 1146 Table ‘db.pm_ping_servers’ doesn’t exist
Query: SELECT server_id, server_name, server_default FROM pm_ping_servers ORDER BY server_order, server_name

- when i try to save a new entry i got quite a lot errors obviously concerning the rss.cp.php. they look like that:
Notice: Undefined index: content_field in /home/www/db_pm/cp/rss.cp.php on line 184

thx very much for any further suggestions

eva_susa

Eva_susa, your best bet is to look at the file insall.php in the pm directory. Look around line 1719 for the changes.

How many entries do you have? Do you have a backup to put you back to the older version?

that was a good hint. i missed five tables which i now have.
but still there are approx. 40 notice statements in the control panel concerning rss.cp.php when i submit a new entry. and this single statement concerning search.fns.php, i.e. on the advanced query page in the control panel.

do you maybe also have any ideas on these issues?

eva_susa

i have now created a second, new weblog inside my upgraded pM version which seems to work better than the original “weblog”. the original one interestingly still poduces the above mentioned bugs whereas the new one produce no errrors at all (i.e. when saving a new entry). as i have posted here my intention to upgrade to pM 2.4 was to be able to migrate to EE core. but i am a little bit confused now, if my upgraded version of pM 2.4 with these errors is stable enough to import it to EE core.

does anyone have an idea how i may detect or test that?

thx
eva_susa

The only way you’re going to know for sure is to actually do it. There really isn’t a better way. You can back up your database prior to importing, but just try it.