04-18-2014, 04:12 AM
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
sql instgram
please any body fix problem
my web site : http://www.exsocial.us
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