MyBB Community Forums

Full Version: SQL Error 1054 when logging in and accessing ACP
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
Okay, let me create a query to create the missing columns then you should be able to deactivate loginconvert.php

RUN the following query:

ALTER TABLE mybb_users ADD (passwordconvert char(120), passwordconverttype int(11), passwordconvertsalt char(120))


The query has been tested.
(2015-05-17, 06:24 PM)Jack.D Wrote: [ -> ]Okay, let me create a query to create the missing columns then you should be able to deactivate loginconvert.php


RUN the following query:


ALTER TABLE mybb_users ADD (passwordconvert char(120), passwordconverttype int(11), passwordconvertsalt char(120))


The query has been tested.

I'm semi-noob, how do I do that?
Go into phpMyAdmin select the database and click SQL paste the query and click run!
(2015-05-17, 06:43 PM)Jack.D Wrote: [ -> ]Go into phpMyAdmin select the database and click SQL paste the query and click run!

I did, I got this error:
[color=#000000][size=small][font=sans-serif]#1146 - Table 'b9_15817171_forum.mybb_users' doesn't exist
Run this:
ALTER TABLE users ADD (passwordconvert char(120), passwordconverttype int(11), passwordconvertsalt char(120))
(2015-05-17, 06:48 PM)Jack.D Wrote: [ -> ]Run this:
ALTER TABLE users ADD (passwordconvert char(120), passwordconverttype int(11), passwordconvertsalt char(120))

Okay, it says my SQL query has been executed successfully. I'll check and see if it works!

Thanks in advance Smile

(2015-05-17, 06:48 PM)Jack.D Wrote: [ -> ]Run this:
ALTER TABLE users ADD (passwordconvert char(120), passwordconverttype int(11), passwordconvertsalt char(120))

It worked! Thanks, you saved me from leaving MyBB and going to some other shitty forum provider, like phpBB3.
Pages: 1 2