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

[gserver2]

Hi friend, in my whmcs later of register show this error:

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

i use whmcs version 7.6.0

any help please i thanks to all members of this forum, im new here

[diasbrasil]

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.

[gserver2]

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

[AngelCosta]

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.

[gserver2]

? any help?

[gserver2]

i install other whmcs more complete, same thanks

[AngelCosta]

8 horas atrás, gserver2 disse:

i install other whmcs more complete, same thanks

so you are using a nulled version, right?