import SQL update 1.3 to 1.4 fails.

graher01 · **Posted:** Tue May 13, 2008 2:02 am

Hi,
I have been trying to import the mysql update from 1.3 to 1.4 and every time I get an error

Error wrote:

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 50
STR: //
SQL:

-- add reseller field in cc_card
--DELIMITER //
--CREATE TRIGGER `after_ins_cc_card` AFTER INSERT ON `cc_card`
-- FOR EACH ROW begin
--
--
-- insert into cc_logrefill(credit,card_id,reseller_id) values(NEW.credit,NEW.id,NEW.reseller);
-- end
--//

SQL query:

-- add reseller field in cc_card --DELIMITER // --CREATE TRIGGER `after_ins_cc_card` AFTER INSERT ON `cc_card` -- FOR EACH ROW begin -- -- -- insert into cc_logrefill(credit,card_id,reseller_id) values(NEW.credit,NEW.id,NEW.reseller); -- end --//

MySQL said: Documentation
#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 '--CREATE TRIGGER `after_ins_cc_card` AFTER INSERT ON `cc_card`
--' at line 1

How can I fix it.

stavros · **Posted:** Tue May 13, 2008 4:01 am

Are you using MySQL 5?

molto · **Posted:** Tue May 13, 2008 6:35 am

Another part should be changed in the update MYSQL 1.3-> 1.4 to:

-- Support / Ticket section
CREATE TABLE cc_card_archive (
id BIGINT NOT NULL,
creationdate TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
firstusedate TIMESTAMP,
expirationdate TIMESTAMP,
enableexpire INT DEFAULT 0,
expiredays INT DEFAULT 0,
username CHAR(50) NOT NULL,
useralias CHAR(50) NOT NULL,
uipass CHAR(50),
credit DECIMAL(15,5) DEFAULT 0 NOT NULL,
tariff INT DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Cheers

Molto

graher01 · **Posted:** Tue May 13, 2008 12:49 pm

stavros wrote:

Are you using MySQL 5?

yes I am using 5.1

graher01 · **Posted:** Wed May 14, 2008 12:04 am

No one have any idea.

graher01 · **Posted:** Wed May 14, 2008 1:39 pm

stavros wrote:

Are you using MySQL 5?

yes I am using MYSQL 5.1 and still having the problem with the latest trunk can anyone tell me how the got it to work.

thanks

areski · **Posted:** Wed May 14, 2008 4:39 pm

we made various changes last days for support mainly!
can you give a try now and let me know if some issues remain.

I might recall the trunk is for dev so it s kind of usual that something is broken :wink:

++, Areski

graher01 · **Posted:** Wed May 14, 2008 5:20 pm

areski wrote:

we made various changes last days for support mainly!
can you give a try now and let me know if some issues remain.

I might recall the trunk is for dev so it s kind of usual that something is broken :wink:

++, Areski

Thanks for the reply. I tried with the lastest code and still not possible to import the update from 1.3 to 1.4 it fails when it tries to add the reseller field like I mention before. I am only testing the new code on a test machine. I am pointing out what I think is broken.

thanks

areski · **Posted:** Wed May 14, 2008 11:03 pm

we tried quickly and didnt find an errors.
weird!

stavros · **Posted:** Thu May 15, 2008 12:58 am

Are you using the mysql command line client to import the schema, or are you using something like PHPMyAdmin?

graher01 · **Posted:** Thu May 15, 2008 1:12 am

stavros wrote:

Are you using the mysql command line client to import the schema, or are you using something like PHPMyAdmin?

I was using PHPMyAdmin

stavros · **Posted:** Thu May 15, 2008 1:35 am

I would suggest therein lies the issue. Use the documented and supported methods for installation please.

graher01 · **Posted:** Thu May 15, 2008 3:41 am

stavros wrote:

I would suggest therein lies the issue. Use the documented and supported methods for installation please.

I am plainning on using the method suggested after I read Areski message. I t might be the problem. thanks for your help.I will post the result once I have a chance to test that.

Added after 1 hours 20 minutes:

graher01 wrote:

stavros wrote:

I would suggest therein lies the issue. Use the documented and supported methods for installation please.

I am plainning on using the method suggested after I read Areski message. I t might be the problem. thanks for your help.I will post the result once I have a chance to test that.

I am happy to report doing the update using the console it worked I tought I could do it using PHPAdmin I guess I was wrokng.

thanks you guys

provided by Star2Billing S.L.

import SQL update 1.3 to 1.4 fails.

Who is online