• From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Topic: Line 1369 in en_US-demo.sql can be removed

@joe: Please check if line 1369 in en-US-demo.sql is necessary - it is dated in 2012:

('1', '0', '001/2012'),

There are many long char fields that should actually be varchar.
All AUTO_INCREMENT=XXX strings can be removed.

apmuthu's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Line 1369 in en_US-demo.sql can be removed

No, hardly not. Will remove it and commit later.

Joe

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Line 1369 in en_US-demo.sql can be removed

Line 1950 needs to be PRIMARY KEY:

 UNIQUE KEY `record_id` (`record_id`,`tag_id`)

Check in en_US-new.sql also.

apmuthu's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Line 1369 in en_US-demo.sql can be removed

This has been fixed and committed to stable repo. The AUTO_INCREMENT removal will wait until later due to backwards compatibility.

Joe

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Line 1369 in en_US-demo.sql can be removed

The following should do the job:

sed -e 's/AUTO_INCREMENT=[0-9]* //g' -i sql/en_US-demo.sql
sed -e 's/AUTO_INCREMENT=[0-9]* //g' -i sql/en_US-new.sql

apmuthu's Website