Error when updating Cobalt, SET pubtime = NOW() WHERE published = 1

I also tried installing just the core pakage, v8.577 and got the same error. Media package updated without issue.

What is your Joomla version?

Joomla 3.2.3

YOu have tablePrefix as prefix or you changed that for security? ANd why DB name is also tablePrefix when it should be a DB name.

I have a production site that uses a databse named 'wdev2'. The table prefixes for that Joomla install are 'wdev2_'

I have a development enviornment where I do all of my test updates. The database for this is 'wdev1' and the table prefix is 'wdev2_' as I juct copy the tables over from production.

I wanted to test the Cobalt update on my development side. So the original error message was actually this...

Error 0 SQL=UPDATE wdev2.wdev2_js_res_record SET pubtime = NOW() WHERE published = 1

This confused me because in my development enviornment I would expect to see a wdev1 in there for database name, like this.

Error 0 SQL=UPDATE wdev1.wdev2_js_res_record SET pubtime = NOW() WHERE published = 1

In my dev enviornment the Joomla configuration appear to be correct Database name: wdev1 Table prefix: wdev2_

I apologize for my old naming conventions and any confusion they cause. Is there a way to verify which database Cobalt is connection to? I'm wondering if this error is because the dev site is a copy of production and something needs to be switched to the proper database name?

Thank you. Please let me know if I can clarify anything.

If you look into install.php file of cobalt you will see that this query is the last one in the list of queries. It does not have prefix or DB name in it. Those things are added by Joomla acording to configuration.

Unfortunately I do not know why this tells you that there is an error. because there are many queries the same before this one. And those looks like run normally.

Try to copy query and run it directly.

This is strange,

The error message should be

Error 0 SQL=UPDATE wdev1.wdev2_js_res_record SET pubtime = NOW() WHERE published = 1

But instead it has wdev2 for the database name? The Global config is correct, so I am wondering where the wdev2 as the database name is coming from.

As expected running the following command directly works because it has the correct db name.

UPDATE wdev1.wdev2_js_res_record SET pubtime = NOW() WHERE published = 1

The problem definitely seems to be the wrong db name in the query, but I am not sure where it is coming from.

But why? Just one line before this query, there is another one. Almost the same and reports no errors.

I agree, it makes no sense. I will continue to work on this and see if I can come up with anything.