I have been trying to update my site from 1.2.1 to later versions and cannot do it.  I get this message when I looked at the log, referencing lines 74 and 114 in the mysql.php file.

I installed a test 1.2.4 version with an empty data base, exported the entire database from 1.2.1 and tried to import. It failed. I then download each individual data type and tried to import those. Some worked, some failed. In other words it doesn't work.

Any ideas specific to the line 74 and 114 problems, or how to make the data export/import work?


    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);
         }
       }
     }
Modify message

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?

I just saw this and will make the changes. Thank you.

Is there a way to avoid showing the price until the prospect clicks the price link? In other words, a too low to show tease and "Click this link to see our actual selling price."

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

I've looked at v1.2 and don't see a Call for Price button to avoid listing the price. It's sometimes called a Too low to show, Call for Price and sometimes... Price will show in the shopping cart.

All of these help sales and avoid the manufacturers' requests not to sell their products too cheaply.

Does it have anything like those features?

I tried both of these workarounds to avoid listing price, that would only show in the shopping basket. Neither did the job.

For now we have few features might help you:
Global setting Login Display Prices: Show/Hide prices if customer is not logged in.
Each product have setting Block Product From Ordering: This will put product to display mode only with no ability to order. Contact us for order message will be displayed.

Global settings - by definition affect the entire website not a particular product that the manufacturer doesn't want to show deep discounts.

Block Product From Ordering doesn't work as the prospect has no idea what the pricing is.

What I'm looking for is a granular way of -

1   Only showing the extra discounted price in the shopping basket, so that only the approved discount is visible before "buying." Amazon does this all of the time.
2   A pop up message or similar to call for bigger discount. The options textbox works but it's scrollable and doesn't show a lot of text without scrolling.

Here are the images showing what the bug does. It changes sales price increments randomly. It is so frequent that I must make a screen capture prior to saving changes, as the system screws up the pricing that has to be manually applied by referring to the before screen image.

I can only attach one image at a time.