Tfs error

[Wipflash]

Hi there i got this error (check console log) , but as u guys can see my config is right and xampp is on.. "/

Regards

W

 

[Mooosie]

Write "127.0.0.1" instead of "localhost" in config.lua [Add me Reputation]

 

[Wipflash]

If i do that, i'll get this error -.-

 

[Wipflash]

Bump

 

[Korrex]

You don't have the necessary shop system tables, if you want that fixed install Gesior, or maybe that's Modern.
It's seriously giving you the errors, why don't you just read and learn from it?

 

[Wipflash]

I know it's a table error, but I don't know the "sql" code? (I already have reinstalled the gesior 2 times)

 

[Korrex]

CREATE TABLE IF NOT EXISTS `shop_history` ADD `processed` INT(32) ;

Or smth i'm not sure.

 

[Wipflash]

Error
SQL-question:

CREATE TABLE IF NOT EXISTS  `shop_history` (

`processed` (
INT
)
)
MySQL sa: 

#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 '(INT) )' at line 1

:/

 

[Korrex]

Fel
SQL-fråga:

CREATE TABLE IF NOT EXISTS  `shop_history` (

`processed` (
INT
)
)
MySQL sa: 

#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 '(INT) )' at line 1

:/

Try it now.

 

[Wipflash]

Error
SQL-question:

CREATE TABLE IF NOT EXISTS  `shop_history` ADD  `processed` INT( 32 )

MySQL sa: 

#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 'ADD `processed` INT(32)' at line 1

 

[Korrex]

Error
SQL-question:

CREATE TABLE IF NOT EXISTS  `shop_history` ADD  `processed` INT( 32 )

MySQL sa: 

#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 'ADD `processed` INT(32)' at line 1

For crying out loud xD.

 CREATE TABLE IF NOT EXISTS `shop_history`;

After that run:

ALTER TABLE `shop_history` ADD `processed` INT(11);

 

[Wipflash]

xd i got this error when i inject the first code

Error
SQL-question:

CREATE TABLE IF NOT EXISTS  `shop_history`

MySQL sa: 

#1113 - A table must have at least 1 column

 

[Korrex]

xd i got this error when i inject the first code

Error
SQL-question:

CREATE TABLE IF NOT EXISTS  `shop_history`

MySQL sa: 

#1113 - A table must have at least 1 column

Please, shoot me xD.

CREATE TABLE IF NOT EXISTS `shop_history`(
processed INT(32) NOT NULL;
)

That is it I think.

 

[Wipflash]

Hahahahahha

Fel
SQL-fråga:

CREATE TABLE IF NOT EXISTS  `shop_history` (

 `processed` INT( 32 ) NOT NULL
MySQL sa: 

#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 '' at line 2

 

[Korrex]

Hahahahahha

Fel
SQL-fråga:

CREATE TABLE IF NOT EXISTS  `shop_history` (

 `processed` INT( 32 ) NOT NULL
MySQL sa: 

#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 '' at line 2

Perhaps now.

 

[Wipflash]

Rolf!

Fel
SQL-fråga:

CREATE TABLE IF NOT EXISTS  `shop_history` (

processed INT( 32 ) NOT NULL ;

MySQL sa: 

#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 '' at line 2

 

[Korrex]

Rolf!

Fel
SQL-fråga:

CREATE TABLE IF NOT EXISTS  `shop_history` (

processed INT( 32 ) NOT NULL ;

MySQL sa: 

#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 '' at line 2

Alright I give up, sorry that I couldn't help you ;/

 

[Wipflash]

it's okey
thank u for your time

 

[ahmed30]

DROP TABLE `shop_history`

CREATE TABLE `shop_history`
(
`id` int(11) NOT NULL auto_increment,
`to_name` varchar(255) NOT NULL default '0',
`to_account` int(11) NOT NULL default '0',
`from_nick` varchar(255) NOT NULL,
`from_account` int(11) NOT NULL default '0',
`price` int(11) NOT NULL default '0',
`offer_id` int(11) NOT NULL default '0',
`trans_state` varchar(255) NOT NULL,
`trans_start` int(11) NOT NULL default '0',
`trans_real` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
);

ALTER TABLE `shop_history` ADD `processed` int(11) NOT NULL default '0';

 

[Wipflash]

Thanks man! Repped ofc