Unknown column 'oc_t_user.pk_i_id' in 'where clause' #469
Replies: 6 comments 12 replies
-
|
Run a repair on table.
…On Sat, 1 Jan, 2022, 9:44 pm Defected, ***@***.***> wrote:
I had a Osclass 3.something website. I removed all the files, kept the
database, uploaded new Osclass 5.1.2 and did the DB upgrade in admin.
Now I'm getting fatal errors at random places, wherever user ID is used
for some searching. Like all user items on public profile, searching items
by user in admin, etc.
I have no idea why this might be happening. Anyone has any ideas? The
table and column exist obviously.
ERROR: Unknown column 'oc_t_user.pk_i_id' in 'where clause' in oc-includes/osclass/classes/database/DBCommandClass.php on line no 973 Error Code:1054 with context:
'#0 oc-includes/osclass/classes/database/DBCommandClass.php(973): mysqli->query()
#1 oc-includes/osclass/classes/database/DBCommandClass.php(878): DBCommandClass->execute()
#2 oc-includes/osclass/classes/model/Search.php(579): DBCommandClass->query()
#3 oc-includes/osclass/classes/datatables/ItemsDataTable.php(63): Search->doSearch()
#4 oc-includes/osclass/classes/controller/admin/CAdminItems.php(914): ItemsDataTable->table()
#5 oc-admin/index.php(63): CAdminItems->doModel()
#6 {main}'
—
Reply to this email directly, view it on GitHub
<#469>, or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AAIDQSNCDZRCHMUHUEHAM43UT4R7TANCNFSM5LCUACQA>
.
You are receiving this because you are subscribed to this thread.Message
ID: ***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
Cannot repair InnoDB tables, should I convert them to MyISAM? |
Beta Was this translation helpful? Give feedback.
-
|
Run a Alter query
…On Sat, 1 Jan, 2022, 9:54 pm Defected, ***@***.***> wrote:
Cannot repair InnoDB tables, should I convert them to MyISAM?
—
Reply to this email directly, view it on GitHub
<#469 (reply in thread)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AAIDQSKLWQZGU4SZOYNBW6TUT4TFXANCNFSM5LCUACQA>
.
You are receiving this because you commented.Message ID:
***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
Alter what? MyISAM shouts at me about foreign key errors when I try to convert. |
Beta Was this translation helpful? Give feedback.
-
|
Run query like this it will recreate the same table.
ALTER TABLE `table_name` ENGINE = InnoDB;
…On Sat, 1 Jan, 2022, 10:01 pm Defected, ***@***.***> wrote:
Alter what? MyISAM shouts at me about foreign key errors when I try to
convert.
—
Reply to this email directly, view it on GitHub
<#469 (reply in thread)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AAIDQSPFULGPMDYLAR4ZRRLUT4T7FANCNFSM5LCUACQA>
.
You are receiving this because you commented.Message ID:
***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
Did it now on item and user tables, still same errors. :/ |
Beta Was this translation helpful? Give feedback.
-
|
Without looking at DB structure it's hard to identify the cause. |
Beta Was this translation helpful? Give feedback.
-
|
If you want I can send you some images (tell what you need), or even give you phpMyAdmin login. |
Beta Was this translation helpful? Give feedback.
-
|
Send the phpmyadmin credentials, let's see if that helps.
…On Sat, 1 Jan, 2022, 10:20 pm Defected, ***@***.***> wrote:
If you want I can send you some images (tell what you need), or even give
you phpMyAdmin login.
But I don't wanna waste your time... Another option is to do a clean
install and then import users and ads manually.
—
Reply to this email directly, view it on GitHub
<#469 (reply in thread)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AAIDQSMKCB6MJ2OIIIOALYTUT4WE7ANCNFSM5LCUACQA>
.
You are receiving this because you commented.Message ID:
***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
Sent to your gmail. |
Beta Was this translation helpful? Give feedback.
-
|
In error you have |
Beta Was this translation helpful? Give feedback.
-
|
Also make sure you're using the recommended php version 7.0 - 8.0 |
Beta Was this translation helpful? Give feedback.
-
|
Changed the prefix when posting here. I'm on 8.1 now, you think it's worth trying to downgrade to 8.0? |
Beta Was this translation helpful? Give feedback.
-
|
Yup sure try that.
…On Sat, 1 Jan, 2022, 10:44 pm Defected, ***@***.***> wrote:
Changed the prefix when posting here.
I'm on 8.1 now, you think it's worth trying to downgrade to 8.0?
—
Reply to this email directly, view it on GitHub
<#469 (reply in thread)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AAIDQSJURLNYXS5TVDWZSQDUT4Y6JANCNFSM5LCUACQA>
.
You are receiving this because you commented.Message ID:
***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
Wow that actually made it work. |
Beta Was this translation helpful? Give feedback.
-
|
Thanks a lot man! Now gotta figure what breaks it in 8.1 🤔 |
Beta Was this translation helpful? Give feedback.
-
|
Sure some escaping issues
…On Sat, 1 Jan, 2022, 10:57 pm Defected, ***@***.***> wrote:
Thanks a lot man! Now gotta figure what breaks it in 8.1 🤔
—
Reply to this email directly, view it on GitHub
<#469 (reply in thread)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AAIDQSK536VUIEFDV5DW4Q3UT42ONANCNFSM5LCUACQA>
.
You are receiving this because you commented.Message ID:
***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
From PHP 8.1 changelog
|
Beta Was this translation helpful? Give feedback.
-
I had a Osclass 3.something website. I removed all the files, kept the database, uploaded new Osclass 5.1.2 and did the DB upgrade in admin.
Now I'm getting fatal errors at random places, wherever user ID is used for some searching. Like all user items on public profile, searching items by user in admin, etc.
I have no idea why this might be happening. Anyone has any ideas? The table and column exist obviously.
Server version: 10.4.22-MariaDB MariaDB Server
PHP 8.1.1 (cli) (built: Dec 31 2021 18:10:26) (NTS)
Beta Was this translation helpful? Give feedback.
All reactions