We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 51158
    • 1 Posts
    Hello, I have a problem with attempt to add new multi tv item to the page and saving that.
    The problem appears after transfering from one hosting to another
    Modx Version: Evo 1.0.15
    PHP: 5.6
    Multitv: 1.4.8

    Error massege:

    « MODX Parse Error »
    
    MODX encountered the following error while attempting to parse the requested resource:
    
    « Execution of a query to the database failed - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' published=1, pub_date=1443427920, unpub_date=0, parent=0, template=16, menuinde' at line 1 »
    
    SQL > UPDATE `wspitaly_italywheels`.`modx_site_content` SET introtext='', content='', pagetitle='Каталог', longtitle='', type='document', description='', alias='katalog', link_attributes='', isfolder=0, richtext=, published=1, pub_date=1443427920, unpub_date=0, parent=0, template=16, menuindex=3, searchable=, cacheable=, editedby=1, editedon=1443429466, publishedon=1443427920, publishedby=1, contentType='text/html', content_dispo=0, donthit=0, menutitle='', hidemenu=0, alias_visible= WHERE id='22'
    
    Basic info
    REQUEST_URI :	http://italywheels.com.ua/manager/index.php
    Manager action :	5 - Saving resource
    Referer :	http://italywheels.com.ua/manager/index.php?a=27&id=22
    User Agent :	Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.99 Safari/537.36
    IP :	194.44.212.3
    Benchmarks
    MySQL :	0,0057 s (19 Requests)
    PHP :	0,0355 s
    Total :	0,0411 s
    Memory :	1,5184555053711 mb
    
    Backtrace
    1	include_once()
    manager/index.php on line 300
    2	DBAPI->update()
    manager/processors/save_content.processor.php on line 539
    3	DBAPI->query()
    manager/includes/extenders/dbapi.mysql.class.inc.php on line 263


    Please, help with that [ed. note: lornot last edited this post 11 years ago.]
      • 47401
      • 295 Posts
      have you tried running the same query outside the application either command line or a gui?