sqlite issue

[Joutarn]

Tfs : 0.4
rev : 3884
the image can explain my problem which i tried hard to solve it but i couldn't

 

[Elgenady]

ALTER TABLE  `players` ADD  `cast` TINYINT NOT NULL DEFAULT  '0',
ADD  `castViewers` INT( 11 ) NOT NULL DEFAULT  '0',
ADD  `castDescription` VARCHAR( 255 ) NOT NULL

 

[Joutarn]

ALTER TABLE  `players` ADD  `cast` TINYINT NOT NULL DEFAULT  '0',
ADD  `castViewers` INT( 11 ) NOT NULL DEFAULT  '0',
ADD  `castDescription` VARCHAR( 255 ) NOT NULL

Error while executing query: near ",": syntax error

 

[Elgenady]

ALTER TABLE `players` ADD `cast` TINYINT NOT NULL DEFAULT '0',
ADD `castViewers` INT( 11 ) NOT NULL DEFAULT '0',
ADD `castDescription` VARCHAR( 255 ) NOT NULL

 

[Joutarn]

ALTER TABLE `players` ADD `cast` TINYINT NOT NULL DEFAULT '0',
ADD `castViewers` INT( 11 ) NOT NULL DEFAULT '0',
ADD `castDescription` VARCHAR( 255 ) NOT NULL

same error : Error while executing query: near ",": syntax error
i see that there is no different between ur two replies
its the same code u gave before

 

[Elgenady]

what u use ?? mysql? or sql

 

[Joutarn]

sqlite

 

[Joutarn]

what u use ?? mysql? or sql

?

 

[adric21]

Hello pm, i will help you bro

 

[Joutarn]

BUMP!
please help still have same problem
i can't start my project :'(

 

[Activity]

Cast is working with mysql as it expect so do not try with it, and in my opinion use mysql because it is more Stability than sqlite

 

[Joutarn]

so [ error while saving problem ] because of cast system?

 

[Activity]

so [ error while saving problem ] because of cast system?

Yea, You will need to insert tables and it will work.

ALTER TABLE `players` ADD `cast` TINYINT NOT NULL DEFAULT '0', ADD `castViewers` INT( 11 ) NOT NULL DEFAULT '0', ADD `castDescription` VARCHAR( 255 ) NOT NULL

 

[Joutarn]

Yea, You will need to insert tables and it will work.

this tables for mysql not sqlite i tried to insert it

 

[Joutarn]

can you give me link for clean sources i mean sources without cast system so i can start my project until i transfer sqlite to mysql?

 

[Activity]

this tables for mysql not sqlite i tried to insert it

I know that, and i meant to use it by mysql not sqlite

can you give me link for clean sources i mean sources without cast system so i can start my project until i transfer sqlite to mysql?

Next time use search tool
https://otland.net/threads/backup-of-some-old-sources.199436/

 

[Joutarn]

thx alot rep+