Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Product price chage module for 2.3.4.1


eagleg

Recommended Posts

i get the following error:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

insert into temp_rates values

[TEP STOP]

 

Link to comment
Share on other sites

The columns aren't actually a requirement if you provide values (in the right order) for all the columns.   I.e. it can infer the columns if the values are set up to match the way that it would infer the columns. 

Now that said, this could indicate a problem if the code is supposed to be specifying the columns but isn't.  But it also may be intentionally using the shorter format.  The support thread used to be at

but I don't know if @BrockleyJohn monitors it actively or not.  You might try posting there and seeing if he has additional insight. 

Always back up before making changes.

Link to comment
Share on other sites

5 hours ago, eagleg said:

i get the following error:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

insert into temp_rates values

[TEP STOP]

 

 https://apps.oscommerce.com/XpKWd&quick-update-bs

this addon?

Link to comment
Share on other sites

@eagleg tax not used?

find

	$insert = 'insert into temp_rates values ';
	foreach ($tax_classes as $id => $data) {
		$insert .= '(' . $id . ',' . $tax_classes[$id]['tax_rate'] . '),';
	}

replace with

      if (!empty($tax_classes)) {
        $insert = 'insert into temp_rates values ';
        foreach ($tax_classes as $id => $data) {
          $insert .= '(' . $id . ',' . $tax_classes[$id]['tax_rate'] . '),';
        }
      }

 

Link to comment
Share on other sites

My copy of that addon does not contain the string ' temp_rates' anywhere (at least not the latest version, I haven't checked any earlier ones)

so I have no idea what @eagleg or @ruden are talking about!

Contact me for work on updating existing stores - whether to Phoenix or the new osC when it's released.

Looking for a payment or shipping module? Maybe I've already done it.

Working on generalising bespoke solutions for Quickbooks integration, Easify integration and pay4later (DEKO) integration at 2.3.x

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...