Alaskan

Hey all! I need some help upgrading from 4.5 (1.0.9) to 4.5.1.
I am attempting to update the database using Mambo's built in dbadmin component under System/Database/Query.

I am using the upgrade45_109to451.sql file from the 4.5.1 beta 4 release.
Entering this command:
INSERT INTO `mos_modules` VALUES (\'\', \'Search\', \'\', 7, \'right\', 0, \'0000-00-00 00:00:00\', 1, \'mod_search\', 0, 0, 1, \'\', 1);

I get this error:
The query was unsuccessful. It return the error code 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near \'\\'\\', \\'Search\\', \\'\\', 7, \\'right\\', 0, \\'0000-00-00 00:00:00\ SQL=INSERT INTO `mos_modules` VALUES (\\'\\', \\'Search\\', \\'\\', 7, \\'right\\', 0, \\'0000-00-00 00:00:00\\', 1, \\'mod_search\\', 0, 0, 1, \\'\\', 1);

I do not have direct access to the database with MySQLadmin or phpAdmin since the Mambo install and database is controlled by Go Daddy.

I hope some of you Mambo-experts can help me complete a successful upgrade to the 4.5.1 Beta.

Thanks!
-John

minotaur

If your accounts are like mine, you CAN use phpMyAdmin at GoDaddy. Use their phpMyAdmin accessible via:
(Menu) Hosting & Email > (drop down item) Web Hosting & Databases (you should see a list of hosted accounts)

Select Databases and then select Open Manager. The Open Manager link opens their version of phpMyAdmin.

Of course, you'll need db id and password to get any further. The phpMyAdmin version is a version by Starlight or Starlink or something like that. Seems to work the same.

Caution if you are managing more than one hosted account with GoDaddy - Don't work on more than one at a time, even if on separate secureservers. Their security gets confused. My IP was blocked from any administration at GoDaddy after working on two or three hosted accounts simultaneously. I had to move to another IP. They provide virtually no support and claimed it was me. I sent sniffed packets to prove that it was them denying me service but to no avail.

Alaskan

I was able to successfully update the database after I installed mosphpmyadmin257 FULL 1.0 (available at mamboforge.net ) and used that to access the database and run the MySQL queries from the upgrade script.

GoDaddy, if they do the install of Mambo as part of their provided free applications, do not include the Mambo database in an area that is accessible by their "database manager." If a user establishes a database on their own and does their own install of Mambo, then they would have access to the database through GoDaddy's manager.

Thanks!
-John

minotaur

That is good to know. I've only installed Mambo myself. I hadn't considered having GoDaddy install Mambo for me. That is a scary thought!

Pleased to hear that your upgrade from 1.0.9 went well. None of my sites are beyond 1.0.9. I should have little to be concerned about then.

Regards.