Как апгрейдить базу?

[Jjunior]

(c) SmartCJ Pro V 2.1

Пытаюсь переехать с сервера, где:
PHP version 5.6.40-15+ubuntu16.04.1+deb.sury.org+1 Mysql Version: 5.7.29-0 ubuntu0.16.04.1

на сервер, где:
PHP version 8.1.2-1 ubuntu2.19 Mysql Version: 8.0.39-0ubuntu0.22.04.1

Сидж не работает из-за ошибок в базе.
Как её конвертить, или что надо сделать, чтоб работало?

[admin]

в базе?
а какие ошибки в базе? конкретнее плз

[Jjunior]

О, да там много чего не работает в скрипте. Проще админку показать, чем описать.
Можно скинуть тебе?

[admin]

что конкретно как конкретно не так работает

если лень описать - установите с 0 скрипт и проблем не будет

[Jjunior]

Да с этого и начинал - устанавливал с ноля, потом базу из бэкапа заливал. Только так и получается хотя бы админку увидеть.

Code: Select all

Так будет что-нибудь понятно?
Warning, you have following CORE errors (You have to fix it and delete those messages from Home - Script Messages after that)

Core error: Mysql error 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 'as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'de' at line 1 (SELECT * FROM as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'delete' AND gallery_id IN ('10122') AND site_id = '1')

Core error: Mysql error 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 'as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'de' at line 1 (SELECT * FROM as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'delete' AND gallery_id IN ('5867') AND site_id = '1')

Core error: Mysql error 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 'as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'de' at line 1 (SELECT * FROM as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'delete' AND gallery_id IN ('10117') AND site_id = '1')

Core error: Mysql error 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 'as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'de' at line 1 (SELECT * FROM as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'delete' AND gallery_id IN ('4473') AND site_id = '1')

Core error: Mysql error 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 'as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'de' at line 1 (SELECT * FROM as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'delete' AND gallery_id IN ('0','10103','10101','10002','10001','10100','10096','10000','10092','10084','10083','9999','10082','10081','10080','9998','9997','9996','9995','10079','10078','5866','10039','10027','10026','10025','10024','10023','10022') AND site_id = '1')

Core error: Mysql error 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 'as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'de' at line 1 (SELECT * FROM as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'delete' AND gallery_id IN ('0') AND site_id = '1')

Core error: Mysql error 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 'as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'de' at line 1 (SELECT * FROM as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'delete' AND gallery_id IN ('10106','4449','10103','4448','4447','10101','4446','10100','10096','10092','10084','10083','10082','10081','10080','10079','10078','5866','10039','10027','10026','10025','10024','10023','10022','10021','10020','10019','10018','10017','10016','10015','10014','10013','10012','10011','10010','10009','10008','10007','10006','10005','10004','10003','10002','10001','10000','9999','9998','9997','9996','9995','9994','9993','9992','9991','9990','9989','9988','9987','9986','9985','9984','9983','9982','9981','9980','9979','9978','9976','9975','9974','9973','9972','9971','9970','9969','9968','9967','9966','9965','9964','9963','9962','9961','9957','9955','9954','9953','9952','9951','9950','9949','9948','9947','9946','9945','9944','8861','7545','6800','6176','6175','6174','6173','6172','6171','6170','6169','6168','6167','6166','6165','6164','6163','6162','6161','6160','6159','6158','6157','6156','6155','6154','6153','6152','6151','6150','6149','6148','6147','6146','6145','6144','6143','6142','6141','6140','6139','6138','6137','6136','6135','6134','6133','6132','6131','6130','6129','6128','6127','6126','6125','6124','6123','6122','6121','6120','6119','6118','6117','6116','6115','6114','6113','6112','6111','6110','6109','6108','6107','6106','6105','6104','6103','6102','6101','6100','6099','6098','6097','6096','6095','6094','6093','6092','6091','6090','6089','6088','6087','6086','6085','6084','6083','6082','6081','6080','6079','6078','6077','6076','6075','6074','6073','6072','6071','6070','6069','6068','6067','6066','6065','6064','6063','6062','6061','6060','6059','6058','6057','6056','6055','6054','6053','6052','6051','6050','6049','6048','6047','6046','6045','6044','6043','6042','6041','6040','6039','6038','6037','6036','6035','6034','6033','6032','6031','6030','6029','6028','6027','6026','6025','6023','6022','6021','6020','6019','6014','6013','6012','6011','6010','6009','6008','6007','6006','6005','6003','6002','6001','6000','5999','5998','5997','5996','5995','5994','5993','5992','5991','5990','5989','5988','5987','5986','5985','5984','5983','5982','5981','5980','5979','5978','5977','5976','5975','5974','5973','5972','5971','5970','5969','5968','5967','5966','5965','5964','5963','5962','5961','5960','5959','5958','5955','5947','5946','5945','5944','5943','5942','5941','5940','5939','5938','5937','5936','5935','5934','5933','5932','5931','5929','5928','5927','5926','5925','5924','5923','5922','5921','5920','5919','5918','5917','5916','5915','5914','5913','5912','5911','5910','5909','5908','5907','5906','5905','5904','5903','5902','5901','5900','5899','5898','5897','5896','5895','5894','5893','5892','5891','5890','5889','5888','5887','5886','5885','5884','5883','5882','5880','5878','5876','5874','5873','5867','5865','5864','5863','5862','5861','5860','5859','5858','5854','5853','5852','5851','5850','5846','5845','5844','5843','5842','5835','5832','5831','5828','5827','5826','5824','5823','5822','5821','5820','5819','5818','5817','5816','5815','5814','5813','5812','5811','5810','5809','5808','5807','5806','5805','5804','5803','5802','5801','5800','5799','5798','5797','5796','5795','5794','5793','5792','5791','5790','5789','5788','5787','5786','5785','5784','5783','5782','5781','5780','5779','5778','5777','5776','5775','5774','5773','5772','5771','5770','5769','5768','5767','5766','5765','5764','5763','5762','5761','5760','5759','5758','5757','5756','5755','5754','5753','5752','5751','5750','5749','5748','5747','5746','5745','5744','5743','5742','5741','5740','5739','5738','5737','5736','5735','5718','5717','5716','5715','5714','5713','5712','5711','5710','5709','5708','5707','5706','5705','5704','5703','5702','5701','5700','5699','5698','5697','5696','5695','5694','5693','5692','5691','5690','5689','5688','5687','5686','5685','5684','5683','5682','5681','5680','5679','5678','5677','5676','5675','5674','5673','5672','5671','5670','5669','5668','5667','5666','5665','5664','5663','5662','5661','5660','5659','5658','5657','5656','5655','5654','5653','5652','5651','5650','5649','5648','5647','5646','5645','5644','5643','5642','5641','5640','5639','5638','5637','5636','5635','5634','5633','5632','5631','5630','5629','5628','5627','5626','5625','5624','5623','5622','5621','5620','5619','5618','5617','5616','5615','5614','5613','5612','5611','5610','5609','5608','5607','5606','5605','5604','5603','5602','5601','5600','5599','5598','5597','5596','5595','5594','5593','5592','5591','5590','5589','5588','5587','5586','5585','5584','5583','5582','5581','5580','5579','5578','5577','5576','5575','5574') AND site_id = '1')

Core error: Mysql error 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 'as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'de' at line 1 (SELECT * FROM as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'delete' AND gallery_id IN ('4449','4448','4447','10106','10103','4446','10101','10100','10096','10092','10084','10083','10082','10081','10080','10079','10078','5866','10039','10027','10026','10025','10024','10023','10022','10021','10020','10019','10018','10017','10016','10015','10014','10013','10012','10011','10010','10009','10008','10007','10006','10005','10004','10003','10002','10001','10000','9999','9998','9997','9996','9995','9994','9993','9992','9991','9990','9989','9988','9987','9986','9985','9984','9983','9982','9981','9980','9979','9978','9976','9975','9974','9973','9972','9971','9970','9969','9968','9967','9966','9965','9964','9963','9962','9961','9957','9955','9954','9953','9952','9951','9950','9949','9948','9947','9946','9945','9944','8861','7545','6800','6176','6175','6174','6173','6172','6171','6170','6169','6168','6167','6166','6165','6164','6163','6162','6161','6160','6159','6158','6157','6156','6155','6154','6153','6152','6151','6150','6149','6148','6147','6146','6145','6144','6143','6142','6141','6140','6139','6138','6137','6136','6135','6134','6133','6132','6131','6130','6129','6128','6127','6126','6125','6124','6123','6122','6121','6120','6119','6118','6117','6116','6115','6114','6113','6112','6111','6110','6109','6108','6107','6106','6105','6104','6103','6102','6101','6100','6099','6098','6097','6096','6095','6094','6093','6092','6091','6090','6089','6088','6087','6086','6085','6084','6083','6082','6081','6080','6079','6078','6077','6076','6075','6074','6073','6072','6071','6070','6069','6068','6067','6066','6065','6064','6063','6062','6061','6060','6059','6058','6057','6056','6055','6054','6053','6052','6051','6050','6049','6048','6047','6046','6045','6044','6043','6042','6041','6040','6039','6038','6037','6036','6035','6034','6033','6032','6031','6030','6029','6028','6027','6026','6025','6023','6022','6021','6020','6019','6014','6013','6012','6011','6010','6009','6008','6007','6006','6005','6003','6002','6001','6000','5999','5998','5997','5996','5995','5994','5993','5992','5991','5990','5989','5988','5987','5986','5985','5984','5983','5982','5981','5980','5979','5978','5977','5976','5975','5974','5973','5972','5971','5970','5969','5968','5967','5966','5965','5964','5963','5962','5961','5960','5959','5958','5955','5947','5946','5945','5944','5943','5942','5941','5940','5939','5938','5937','5936','5935','5934','5933','5932','5931','5929','5928','5927','5926','5925','5924','5923','5922','5921','5920','5919','5918','5917','5916','5915','5914','5913','5912','5911','5910','5909','5908','5907','5906','5905','5904','5903','5902','5901','5900','5899','5898','5897','5896','5895','5894','5893','5892','5891','5890','5889','5888','5887','5886','5885','5884','5883','5882','5880','5878','5876','5874','5873','5867','5865','5864','5863','5862','5861','5860','5859','5858','5854','5853','5852','5851','5850','5846','5845','5844','5843','5842','5835','5832','5831','5828','5827','5826','5824','5823','5822','5821','5820','5819','5818','5817','5816','5815','5814','5813','5812','5811','5810','5809','5808','5807','5806','5805','5804','5803','5802','5801','5800','5799','5798','5797','5796','5795','5794','5793','5792','5791','5790','5789','5788','5787','5786','5785','5784','5783','5782','5781','5780','5779','5778','5777','5776','5775','5774','5773','5772','5771','5770','5769','5768','5767','5766','5765','5764','5763','5762','5761','5760','5759','5758','5757','5756','5755','5754','5753','5752','5751','5750','5749','5748','5747','5746','5745','5744','5743','5742','5741','5740','5739','5738','5737','5736','5735','5718','5717','5716','5715','5714','5713','5712','5711','5710','5709','5708','5707','5706','5705','5704','5703','5702','5701','5700','5699','5698','5697','5696','5695','5694','5693','5692','5691','5690','5689','5688','5687','5686','5685','5684','5683','5682','5681','5680','5679','5678','5677','5676','5675','5674','5673','5672','5671','5670','5669','5668','5667','5666','5665','5664','5663','5662','5661','5660','5659','5658','5657','5656','5655','5654','5653','5652','5651','5650','5649','5648','5647','5646','5645','5644','5643','5642','5641','5640','5639','5638','5637','5636','5635','5634','5633','5632','5631','5630','5629','5628','5627','5626','5625','5624','5623','5622','5621','5620','5619','5618','5617','5616','5615','5614','5613','5612','5611','5610','5609','5608','5607','5606','5605','5604','5603','5602','5601','5600','5599','5598','5597','5596','5595','5594','5593','5592','5591','5590','5589','5588','5587','5586','5585','5584','5583','5582','5581','5580','5579','5578','5577','5576','5575','5574') AND site_id = '1')

Core error: Mysql error 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 'as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'de' at line 1 (SELECT * FROM as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'delete' AND gallery_id IN ('10059') AND site_id = '1')

Core error: Mysql error 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 'as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'de' at line 1 (SELECT * FROM as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'delete' AND gallery_id IN ('10000') AND site_id = '1')

Core error: Mysql error 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 'as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'de' at line 1 (SELECT * FROM as g2t LEFT JOIN rot_tags AS t on t.tag_id = g2t.tag_id WHERE status != 'delete' AND gallery_id IN ('10064') AND site_id = '1')

[admin]

то что у меня в подписи каждого сообщения - сделано?

ошибки после этого удалены?

[Jjunior]

Разумеется, это сделано. Но нет, не лечится таким образом.

[admin]

тогда не знаю
скидывайте админку и шел

[Jjunior]

Спасибо! Скину.

[admin]

ok