Sergeyka
В общем после переезда с одного сервака на другой, при попытке во вкладке Summary зайти туда и перегенерить морду, выдает ошибку
can't create temporary table
хэлпер по скрипту так расшифровывает
If you see this error, your mysql user does not have CREATE TEMPORARY TABLES privilege to be able to create temporary tables.
обратились к хостеру, тот говорит, что проблема в скриптах
Проблема в скриптах:
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 'TYPE=MyISAM SELECT st_galleries.type,st_galleries.text,st_galleries.wm_approved,' at line 1|/st/admin/rotator.php
полный лог тут
2015-10-14 12:11:08|0.0002 sec|CREATE TEMPORARY TABLE `st_galleries_temp1` (INDEX (`enabled`, `auto_crop`)) TYPE=MyISAM SELECT st_galleries.type,st_galleries.text,st_galleries.wm_approved,st_galleries.auto_crop,st_galleries.auto_crop_domain_id,st_galleries.delete,st_galleries.spot_status,st_galleries.text_description,st_galleries.md5_check,st_galleries.md5_enabled,st_galleries_1.listed, st_galleries_1.text_listed, st_galleries_1.enabled, st_galleries_1.totalclicks,st_galleries_1.text_totalclicks,st_galleries_1.subcatsites_totalclicks,st_galleries_1.casts, st_galleries_1.text_casts,st_galleries_1.subcatsites_casts, st_galleries_1.subcatsites_text_totalclicks, st_galleries_1.subcatsites_text_casts, st_galleries_1.subcatsites_text_listed, st_galleries_1.subcatsites_listed, st_galleries_1.spot_type, st_galleries_1.auto_disabled, st_galleries.md5_result, st_galleries_1.active, st_galleries_1.text_active, st_galleries_1.text_lastclicks, st_galleries_1.lastclicks FROM st_galleries left join st_sponsors on st_galleries.sponsorID=st_sponsors.id inner join st_categories on st_galleries.category=st_categories.id inner join st_galleries_1 on st_galleries.ID=st_galleries_1.ID WHERE FIND_IN_SET(1,st_sponsors.enabled) AND FIND_IN_SET(1,st_categories.enabled)|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 'TYPE=MyISAM SELECT st_galleries.type,st_galleries.text,st_galleries.wm_approved,' at line 1|/st/admin/rotator.php|80.83.237.5|Mozilla/5.0 (Windows NT 6.3; WOW64; rv:41.0) Gecko/20100101 Firefox/41.0
2015-10-14 12:46:32|0.0002 sec|CREATE TEMPORARY TABLE `st_galleries_temp1` (INDEX (`enabled`, `auto_crop`)) TYPE=MyISAM SELECT st_galleries.type,st_galleries.text,st_galleries.wm_approved,st_galleries.auto_crop,st_galleries.auto_crop_domain_id,st_galleries.delete,st_galleries.spot_status,st_galleries.text_description,st_galleries.md5_check,st_galleries.md5_enabled,st_galleries_1.listed, st_galleries_1.text_listed, st_galleries_1.enabled, st_galleries_1.totalclicks,st_galleries_1.text_totalclicks,st_galleries_1.subcatsites_totalclicks,st_galleries_1.casts, st_galleries_1.text_casts,st_galleries_1.subcatsites_casts, st_galleries_1.subcatsites_text_totalclicks, st_galleries_1.subcatsites_text_casts, st_galleries_1.subcatsites_text_listed, st_galleries_1.subcatsites_listed, st_galleries_1.spot_type, st_galleries_1.auto_disabled, st_galleries.md5_result, st_galleries_1.active, st_galleries_1.text_active, st_galleries_1.text_lastclicks, st_galleries_1.lastclicks FROM st_galleries left join st_sponsors on st_galleries.sponsorID=st_sponsors.id inner join st_categories on st_galleries.category=st_categories.id inner join st_galleries_1 on st_galleries.ID=st_galleries_1.ID WHERE FIND_IN_SET(1,st_sponsors.enabled) AND FIND_IN_SET(1,st_categories.enabled)|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 'TYPE=MyISAM SELECT st_galleries.type,st_galleries.text,st_galleries.wm_approved,' at line 1|/st/admin/rotator.php|85.94.105.232|Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36
и говорит, что они помочь не могут, кто сталкивался с такой фигней, как лечить?