Blog Documentation Book a Demo

You have an error in your SQL syntax, Migrating from 2.3 to 2.5.1

EdwinJuradoEdwinJurado New
in Vanilla 2.0 - 2.8

good day to all, I am writing to you in the forum because I have a problem since I migrated from vanilla 2.3 to 2.5.1 that I have not been able to solve.

I made the migration with the importer and apparently everything went well, but I began to get reports from users who could not register an account in the forum and they came up with the following error:

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 ' p.Name as `Name`
from GDN_c `c`
left join GDN_p `p` on c. = p.ID' at line 1
## /home/forum/domains/forum.com/public_html/forum/library/database/class.database.php(407)
#0 [internal function]: gdn_ErrorHandler(256, 'You have an err...', '/home/forum...', 407, Array)
#1 /home/forum/domains/forum.com/public_html/forum/library/database/class.database.php(407): trigger_error('You have an err...', 256)
#2 /home/forum/domains/forum.com/public_html/forum/library/database/class.sqldriver.php(1684): Gdn_Database->query('select distinct...', Array, Array)
#3 /home/forum/domains/forum.com/public_html/forum/library/database/class.sqldriver.php(629): Gdn_SQLDriver->query('select distinct...')
#4 /home/forum/domains/forum.com/public_html/forum/applications/dashboard/models/class.permissionmodel.php(595): Gdn_SQLDriver->get()
#5 /home/forum/domains/forum.com/public_html/forum/applications/dashboard/models/class.permissionmodel.php(731): PermissionModel->getJunctionPermissions(Array, '', '', Array)
#6 /home/forum/domains/forum.com/public_html/forum/applications/dashboard/models/class.rolemodel.php(386): PermissionModel->getPermissions(Array, '')
#7 /home/forum/domains/forum.com/public_html/forum/applications/dashboard/models/class.usermodel.php(1732): RoleModel->getPermissions(Array)
#8 /home/forum/domains/forum.com/public_html/forum/library/core/class.session.php(431): UserModel->getSession('58846')
#9 /home/forum/domains/forum.com/public_html/forum/applications/dashboard/controllers/class.entrycontroller.php(1547): Gdn_Session->start('58846')
#10 /home/forum/domains/forum.com/public_html/forum/applications/dashboard/controllers/class.entrycontroller.php(1401): EntryController->registerBasic('')
#11 /home/forum/domains/forum.com/public_html/forum/library/core/class.dispatcher.php(833): EntryController->register('')
#12 /home/forum/domains/forum.com/public_html/forum/library/core/class.dispatcher.php(262): Gdn_Dispatcher->dispatchController(Object(Gdn_Request), Array)
#13 /home/forum/domains/forum.com/public_html/forum/index.php(29): Gdn_Dispatcher->dispatch()
#14 {main}
I did the processes that they recommend and I ran as much / dashboard / utility / update as / dashboard / utility / update but I keep presenting the problem

Do you have any solution?

Comments

  • R_JR_J Admin

    The importer is for importing other forums data to Vanilla. Please read the Instructions on how to upgrade

  • EdwinJuradoEdwinJurado New

    @R_J I did the steps of the migration as indicated, I sold the error, also eexporte with vanilla2export.php also the error comes out.

  • R_JR_J Admin

    From the porters description: "DO NOT USE THIS FOR UPGRADING BETWEEN VANILLA 2.X VERSIONS"

    These are the upgrading instructions
    They are linked from multiple places, e.g. here

Sign In or Register to comment.