hi all
i install pes pro 2.0.2 + 7 lan + 4 xtra module
and instgram module not work and clint id in admin panel not save
when enter sql this not accept
Code:
Error
SQL query:
REATE TABLE IF NOT EXISTS `instagram` ( `id` int( 11 ) NOT NULL AUTO_INCREMENT , `user` int( 255 ) NOT NULL , `inst_id` int( 255 ) NOT NULL default '0', `url` varchar( 255 ) COLLATE utf8_unicode_ci NOT NULL , `title` varchar( 255 ) COLLATE utf8_unicode_ci NOT NULL , `p_av` varchar( 255 ) COLLATE utf8_unicode_ci NOT NULL , `clicks` int( 255 ) NOT NULL default '0', `active` int( 11 ) NOT NULL default '0', `cpc` int( 11 ) NOT NULL default '2', `country` varchar( 64 ) NOT NULL default '0', `sex` int( 11 ) NOT NULL default '0', PRIMARY KEY ( `id` ) , KEY `active` ( `active` ) , KEY `cpc` ( `cpc` ) ) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci AUTO_INCREMENT =1;
MySQL said:
#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 'REATE TABLE IF NOT EXISTS `instagram` (
`id` int(11) NOT NULL auto_increment,' at line 1
sql instgram
Code:
CREATE TABLE IF NOT EXISTS `instagram` (
`id` int(11) NOT NULL auto_increment,
`user` int(255) NOT NULL,
`inst_id` int(255) NOT NULL default '0',
`url` varchar(255) collate utf8_unicode_ci NOT NULL,
`title` varchar(255) collate utf8_unicode_ci NOT NULL,
`p_av` varchar(255) collate utf8_unicode_ci NOT NULL,
`clicks` int(255) NOT NULL default '0',
`active` int(11) NOT NULL default '0',
`cpc` int(11) NOT NULL default '2',
`country` varchar(64) NOT NULL default '0',
`sex` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `active` (`active`),
KEY `cpc` (`cpc`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `instagram_done` (
`user_id` int(255) NOT NULL,
`site_id` int(255) NOT NULL,
KEY `site_id` (`site_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
please any body fix problem
my web site :
http://www.exsocial.us
