Database Errors
Hey,
I have just found my report littered with the following. Any ideas what would be causing this? I did a raft of update a few days ago so guessing something went awry.
Thanks,
Paul.
---
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 ')' at line 1 query: SELECT p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /var/www/modules/user/user.module on line 502.
Type: php
array_keys() [function.array-keys]: The first argument should be an array in /var/www/modules/user/user.module on line 502.
Backtrace: array_keys(a:1:{i:0;N;})[user.module:502] <=user_access(...)[menu.inc:449] <=_menu_check_access(...)[menu.inc:662] <=_menu_link_translate(...)[menu.inc:1025] <=_menu_tree_check_access(...)[menu.inc:1028] <=_menu_tree_check_access(...)[menu.inc:1028] <=_menu_tree_check_access(...)[menu.inc:1014] <=menu_tree_check_access(...)[menu.inc:845] <=menu_tree_all_data(...)[admin_menu.module:147] <=admin_menu_footer(a:1:{i:0;i:0;})[:] <=call_user_func_array(...)[module.inc:471] <=module_invoke_all(...)[javascript_aggregator.module:74] <=phptemplate_closure(Array)[:] <=call_user_func_array(...)[theme.inc:617] <=theme(...)[theme.inc:1831] <=template_preprocess_page(...)[:] <=call_user_func_array(...)[theme.inc:658] <=theme(...)[index.php:36] <=index.php
Type: php
implode() [function.implode]: Invalid arguments passed in /var/www/includes/database.inc on line 253.
Backtrace: implode(...)[database.inc:253] <=db_placeholders(a:1:{i:0;N;})[user.module:502] <=user_access(...)[menu.inc:449] <=_menu_check_access(...)[menu.inc:662] <=_menu_link_translate(...)[menu.inc:1025] <=_menu_tree_check_access(...)[menu.inc:1028] <=_menu_tree_check_access(...)[menu.inc:1028] <=_menu_tree_check_access(...)[menu.inc:1014] <=menu_tree_check_access(...)[menu.inc:845] <=menu_tree_all_data(...)[admin_menu.module:147] <=admin_menu_footer(a:1:{i:0;i:0;})[:] <=call_user_func_array(...)[module.inc:471] <=module_invoke_all(...)[javascript_aggregator.module:74] <=phptemplate_closure(Array)[:] <=call_user_func_array(...)[theme.inc:617] <=theme(...)[theme.inc:1831] <=template_preprocess_page(...)[:] <=call_user_func_array(...)[theme.inc:658] <=theme(...)[index.php:36] <=index.php
Type: php
array_fill() [function.array-fill]: Number of elements must be positive in /var/www/includes/database.inc on line 253.
Backtrace: array_fill(...)[database.inc:253] <=db_placeholders(a:1:{i:0;N;})[user.module:502] <=user_access(...)[menu.inc:449] <=_menu_check_access(...)[menu.inc:662] <=_menu_link_translate(...)[menu.inc:1025] <=_menu_tree_check_access(...)[menu.inc:1028] <=_menu_tree_check_access(...)[menu.inc:1028] <=_menu_tree_check_access(...)[menu.inc:1014] <=menu_tree_check_access(...)[menu.inc:845] <=menu_tree_all_data(...)[admin_menu.module:147] <=admin_menu_footer(a:1:{i:0;i:0;})[:] <=call_user_func_array(...)[module.inc:471] <=module_invoke_all(...)[javascript_aggregator.module:74] <=phptemplate_closure(Array)[:] <=call_user_func_array(...)[theme.inc:617] <=theme(...)[theme.inc:1831] <=template_preprocess_page(...)[:] <=call_user_func_array(...)[theme.inc:658] <=theme(...)[index.php:36] <=index.php
=-=
you can begin disabling modules one at a time until the error no longer presents itself in an attempt to narrow down where the static is coming from.
I assume you've optimized and checked all tables in the database to ensure none of them need repairing?
Hi, Thank you for your
Hi,
Thank you for your advice. I will do so, starting with the ones I know I updated recently.
I have optimized and checked the database. I found the following and repaired (to no effect).
tt_main.uc_order_products_pair_vw repair Error 'tt_main.uc_order_products_pair_vw' is not BASE TA...
tt_main.uc_order_products_pair_vw repair error Corrupt
tt_main.uc_order_products_qty_vw repair Error 'tt_main.uc_order_products_qty_vw' is not BASE TAB...
tt_main.uc_order_products_qty_vw repair error Corrupt
tt_main.uc_order_products_user_vw repair Error 'tt_main.uc_order_products_user_vw' is not BASE TA...
I don't think this is linked to the problem I am having. Everything else said OK. I am starting my modules one by one and will let you know the progress. I appreciate the help.
Thanks,
Paul.
Hi, I managed to locate the
Hi,
I managed to locate the problem. It was with uc_who_bought_what, a ubercart module. I think the messages above are the same module so I am going to raise an issue.
Thanks for your help,
Paul.