update from 1.2.1

[alevene]

I've been using version 1.2.1 for a while and used a custom table prefix having replaced abc_xxx. I have been unable to upgrade to 1.2.2, 1.2.3 and now 1.2.4 as I always got a critical error. I believed that the non-standard table names were the problem.

I copied the entire folder set to another web folder, changed the tables prefixes to abc_ and changed it in the config.php file. It worked fine as I now have an identical "backup" of the original website as if I migrated it to another ISP.

The problem is that I have the same problem. I cannot update the system so abc_ may have been just one of the problems.

Suggestions?


AbanteCart core upgrade to v1.2.2 is now available

Message status:
    notice

Date:
    09/23/2015 01:26:01 PM

Number of repetitions:
    7

You can upgrade AbanteCart core now. Upgrade is for version 1.2.1 and will change your AbanteCart application to version 1.2.2 Please click following link this link to start the upgrade.

followed by -

There has been a critical error processing your request
Please check AbanteCart and webserver error logs for more details. You can check error log in the control panel if it is functional. Otherwise, refer to error log located on your web server

[webdevmerc]

I don't know about this specific error, but I've never been able to get the auto update to work myself and would recommend you try to upgrade manually and see if you have more luck.  Try on a test environment first if you have live data or are already live...

http://docs.abantecart.com/pages/upgrade/manual.html

[llegrand]

the standard prefix for abantecart database  is "ac_"  this need to be done PRIOR to running an update.

I find that changing the db prefix to that solves the issue nicely.  It can easily be done within the myPhpAdmin.

Lee

[alevene]

I changed the mysql tables from _abc to _ac; edited the config file and attempted an upgrade to 1.2.2. It failed with a similar message. When I looked at the log, referencing lines 74 and 114 in the mysql.php file I found this. Any idea what the fix is?


    public function query($sql, $noexcept = false) {
      //echo $this->database_name;
       $time_start = microtime(true);
LINE 74 ->      $resource = mysql_query($sql, $this->connection);
        $time_exec = microtime(true) - $time_start;


      if($noexcept){
            $this->error = 'AbanteCart Error: ' . mysql_error($this->connection) . '<br />Error No: ' . mysql_errno($this->connection) . '<br />' . $sql;
            return FALSE;
         }else{
LINE 114 ->            throw new AException(AC_ERR_MYSQL, 'Error: ' . mysql_error($this->connection) . '<br />Error No: ' . mysql_errno($this->connection) . '<br />' . $sql);
         }
       }
     }

[alevene]

I've continued to work on this and have tried the manual update process and the "load extensions" method. Nothing works yet.

I am not sure what this means. I've copied the update files to the root of the test domain and open the phpMyAdmin window via the cPanel of my web hosting company. I'm not sure how to execute the upgrade.sql from within the phpMyAdmin.

------

6. Finally run modified upgrade.sql file in MySQL (command line, phpMyAdmin or other )

[alevene]

I installed a new version of 1.2.1 this weekend and restored the ac_ mysql tables to a new database. I thought that it was possible that some edits were blocking the upgrade to 1.2.2. I have the save errors as above.

It appears that 1.2.2 doesn't like the database.

Suggestions?

[alevene]

Does anyone have some ideas of resolving this roadblock to updating from 1.2.1?

When I looked at the log, referencing lines 74 and 114 in the mysql.php file I found this. Any idea what the fix is?


    public function query($sql, $noexcept = false) {
      //echo $this->database_name;
       $time_start = microtime(true);
LINE 74 ->      $resource = mysql_query($sql, $this->connection);
        $time_exec = microtime(true) - $time_start;


      if($noexcept){
            $this->error = 'AbanteCart Error: ' . mysql_error($this->connection) . '<br />Error No: ' . mysql_errno($this->connection) . '<br />' . $sql;
            return FALSE;
         }else{
LINE 114 ->            throw new AException(AC_ERR_MYSQL, 'Error: ' . mysql_error($this->connection) . '<br />Error No: ' . mysql_errno($this->connection) . '<br />' . $sql);
         }
       }
     }
[/i]