Update from 2.0.1 to 2.0.3.1 Database error

[koraldon]

Hi,
I have started the update process from v1.3.5 to v2.0.7 (using joomla 1.0.13)
The first database update went smooth, however on the second DB updated (2.0.1->2.0.3.1) I get the following error:

/var/hsphere/local/home/pundak/pundak.co.il/includes/database.php:485
/var/hsphere/local/home/pundak/pundak.co.il/administrator/components/com_simple_review_db_updater/classes/common.php:676
/var/hsphere/local/home/pundak/pundak.co.il/administrator/components/com_simple_review_db_updater/admin.simple_review_db_updater.php:44
/var/hsphere/local/home/pundak/pundak.co.il/administrator/components/com_simple_review_db_updater/admin.simple_review_db_updater.php:35
/var/hsphere/local/home/pundak/pundak.co.il/administrator/index2.php:69DB function failed with error number 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 'WHERE Key_Name = 'idx_srr_blurb_content'' at line 1 SQL=SHOW INDEX FROM jos_simplereview_review WHERE Key_Name = 'idx_srr_blurb_content';1064
Tried to drop index idx_srr_content

No clue how to continue...

[NRyan115]

Hello,

The developer for this component will be away for another couple of weeks and may not be able to assist with this issue while he is away. Unfortunately, while I am here to help out I do not know anything about SQL.

I also want to point out that at best you will only be able to use up to version 2.0.7 with Joomla 1.0. At worst you may not get any support help even after the developer returns. According to the archives in November 2009 this was posted on the front page:

Upgrade 2.0.7 to 2.1.0 Available
Wednesday, November 25th, 2009

Joomla 1.5 only. Joomla 1.0 is no longer supported.

I do not know if he meant that future releases will not support Joomla 1.0 or if he meant that he himself and the support forums will no longer support Joomla 1.0. I'm not sure.
I do know that so much has changed (and I also know that so much is also about to change with the next release) both in terms of bug fixes and also with features and user interface. I would not recommend using such an old version of Simple_Review unless you have no other choice.

Perhaps when Row gets back he will be able to help you get to version 2.0.7 - but I would consider if sticking with an older joomla version is the best thing for you and your site. I have already installed one of the Joomla 1.6 betas which are soon to become releases. My only point is that Joomla 1.0 is a few years old and Simple Review is moving in a great direction. Would hate for you to not be able to enjoy it.

But in any case, you should also post your MySQL version if you hope to get help once the developer comes back.

[koraldon]

Hi,
MySql Version is 5.0.51a.
I intend not to update the whole joomla site, if it works, don't change it. Maybe when V1.6 is out i will give it a go. However, in any case I will need to do it step by step, there is no direct v1.3.5-> V2.2 update.
The reason i upgraded simple-review is for the new comments and stars feature... I hope I don't regret it.

Anyway, is there an option to post here what querys I should run on the DB? as I have access to Mysql directly, so maybe I can workaround - if it is only an interface problem.

[NRyan115]

Again unfortunately I cant help you with SQL you have to wait for the developer to return. I do not have any exact dates, was just told in an email that he would be absent for a while. I am just doing my best to hold down the fort.

I do find it odd though that the file in question with the SQL error is not a Simple Review file, butt rather a joomla file (administrator/index2.php) I believe that would be line 69. Perhaps it is a bug? Not that I am an expert since I have been using 1.5 since it came out but didn't they patch joomla to 1.0.20+ so it sounds like your 1.0.13 is an old version of the old joomla.

I am not saying this is your problem I am just trying to make educated guessing while you wait

[koraldon]

Hi,
I have edited both the updater files, to drop the following "check" -

   $converted = SRDBWrapper::Query("SHOW INDEX FROM #__simplereview_review WHERE Key_Name = 'idx_srr_blurb_content';");
   if(count($converted) > 1)
   {
      SRError::Display('Database has already been upgraded.', true);         
   }

The upgrade continued without a hitch - successes all around :-)
Looked at the tables manualy, both review and components seems to be updated with the changes (fulltext in the reviews, additional entries in the components).
I will now continue with files update and hope all will be good.

[row1]

Hi,

Nice work on working around that - not sure why that index didn't work.
Please make sure you apply each incremental update.

*Backup all your Simple Review tables and files.
*Apply each database update (ignore the file updates).
Then:
Option 1: Uninstall Simple Review. Install the latest version. Restore your Simple Review tables.
Option 2: Delete the contents of the two simple review component folders (www/components/com_simple_review & www/administrator/components/com_simple_review) Unzip the latest version of the Simple Review component and upload them into the above.

The above *should* go smoothly and save you some time and reduce the error of forgetting to upload files. Of course do it at your own risk 

[koraldon]

Hi,
This is what I did to get to ver 2.2.4,
Which is now running smooth.