Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Try Vanilla Forums Cloud product
Vanilla 2.6 is here! It includes security fixes and requires PHP 7.0. We have therefore ALSO released Vanilla 2.5.2 with security patches if you are still on PHP 5.6 to give you additional time to upgrade.

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

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

Sign In or Register to comment.