Jump to content

Ooops error register ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'optin' in 'field list'


Recommended Posts

Hi, verify this option field !

Check the database

If you just migrated the database from different hosting or upload from local host, you may have some errors during database dump creation. Check the sql file on any editor

Check the database

If you just migrated the database from different hosting or upload from local host, you may have some errors during database dump creation. Check the sql file on any edito

Alter table name to fix MySQL 1054 Error

You may need to alter the column name.

Link to comment
Share on other sites

29 minutos atrás, diasbrasil disse:

Hi, verify this option field !

Check the database

If you just migrated the database from different hosting or upload from local host, you may have some errors during database dump creation. Check the sql file on any editor

Check the database

If you just migrated the database from different hosting or upload from local host, you may have some errors during database dump creation. Check the sql file on any edito

Alter table name to fix MySQL 1054 Error

You may need to alter the column name.

the problem is what not know what table have this field 'option' or 'optin' in the error appears tlb.... not show the name of table what contain this field is the problem, i don't can identify

Link to comment
Share on other sites

  • Administration
15 horas atrás, gserver2 disse:

the problem is what not know what table have this field 'option' or 'optin' in the error appears tlb.... not show the name of table what contain this field is the problem, i don't can identify

Just going out on a limb here... Is your whmcs original? We've seen some errors in nulled copies and some have corrupted tables. 

Well, to fix your issue, you'd need to either recreate that table/column or run some sql to restore the database to its original state.

If this was about a newer version, I'd be able to provide you with a blank whmcs database sql, but I don't have that for your version.

https://netmundocom.br/ - Soluções Web

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

Do you agree with our terms?