Errors loading new 1.6 install

[dig814]

Can anyone tell me why this error occurs? I created a quickstart packeage. I tested on 2 different servers. Had no problems. Now I have 3 different people that receive same errors and I can't seem to understand why. In the back end, the get

Code: Select all

Error loading module Unknown column 'm.publish_up' in 'where clause' SQL=SELECT id, title, module, position, content, showtitle, params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2011-05-04 16:59:44') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-05-04 16:59:44') AND m.access IN (1,1) AND m.client_id = 1 AND (mm.menuid = 0 OR mm.menuid <= 0) ORDER BY position, ordering

And can't login. Front end give 404, but going to search, I see this error:

Code: Select all

        * JERROR_LOADING_MENUS
        * Error loading module Unknown column 'm.publish_up' in 'where clause' SQL=SELECT id, title, module, position, content, showtitle, params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2011-05-04 16:41:24') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-05-04 16:41:24') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 0 OR mm.menuid <= 0) ORDER BY position, ordering

I can't seem to duplicate errors so I am unsure how to fix.

Thanks

[Per Yngve Berg]

There is a field "publish_up" missing in the jos_modules table. Inspect the database with phpmyadin.

What exactly did you do?

With "quickstart packeage" do you mean kickstart from Akeeba backup?

[dig814]

I solved it. It was not for Akeeba. I am a template developer and create "Quickstart" packages for our templates. We call ours Point.Click.GO!. I create a database dump from PHP Myadmin. Then I edit the sql file removing unneeded portions and save this as sample_data.sql to replace the core Joomla one for our packages.

I created a new database dump and went over it very carefully. There were a few references to localhost that I think caused the problem. I removed them, created the new file and had one of the people having the issue test it for me and it worked.

Thanks for your input.

Dan