X-Cart forums

[www.cheapglasses.net]

Breadcrumb fluid, right not full.

[nauticalstyle]

Unfortunately I haven't kept up with all the updates that Phil has put out over the last few years, but I'm back on the PC now, determined to get the ReBOOT(ReDUX) template fully updated and running like a Swiss watch, but as is usual for me, I've come across a stumbling block...

While trying to implement the v4.7.12.5 Security & Testimonials update from June 10 2021, the database patch is throwing up a SQL syntax error in the first few lines of code.

I'm running XAMPP v3.3.0, with Apache and MySQL, and MariaDB v10.4.18, on a Windows 10 PC.

Here's the relevant section of code from the patch.sql file that produces the error code 1064:

DROP TABLE IF EXISTS reboot_visitors;
CREATE TABLE IF NOT EXISTS reboot_visitors (
id int(11) NOT NULL AUTO_INCREMENT,
time int(20) NOT NULL,
ip varchar(50) NOT NULL,
city varchar(255) NOT NULL,
region varchar(255) NOT NULL,
country varchar(255) NOT NULL,
org varchar(255) NOT NULL,
host varchar(255) NOT NULL,
referer varchar(255) NOT NULL,
useragent varchar(255) NOT NULL,
device varchar(1) NOT NULL,
blocked varchar(1) NOT NULL DEFAULT 'N',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#REPLACE INTO `reboot_visitors` (`id`, `time`, `ip`, `city`, `region`, `country`, `org`, `host`, `referer`, `useragent`, `device`, `blocked`) VALUES
(1, 1622817139, '**.**.**.**', 'City', 'Region', 'US', 'Example Org', 'Example Host Name', 'https://example.com', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:89.0) Gecko/20100101 Firefox/89.0', 'D', 'Y');


The SQL error log file says:

SQL query : (1, 1622817139, '**.**.**.**', 'City', 'Region', 'US', 'Example Org', 'Example Host Name', 'https://example.com', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:89.0) Gecko/20100101 Firefox/89.0', 'D', 'Y')
Error code : 1064
Description : 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 '1, 1622817139, '**.**.**.**', 'City', 'Region', 'US', 'Example Org', 'Example...' at line 1

[pauldodman]

The code seems to be commented out - you have


#REPLACE INTO


remove the #


REPLACE INTO

[nauticalstyle]

Thanks pauldodman, I found the error in patch.sql. I just had to make sure that if a segment of code is commented out, with a # at the beginning of the line, then the complete segment of code must be on one line in the editor.