I get the following error when I turn Debug on.

select * from xoops_tb_tabs order by parent_id , tb_ord Desc
select * from xoops_tb_tabs where parent_id=1 order by tb_ord DESC
select parent_id from xoops_tb_tabs where id=1 order by tb_ord DESC
select * from xoops_tb_tabs where parent_id=0 order by tb_ord DESC
select parent_id from xoops_tb_tabs where id=0 order by tb_ord DESC
select * from xoops_tb_tabs where parent_id= order by tb_ord DESC
Error number: 1064
Error message: 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 'order by tb_ord DESC' at line 1

Has anyone had this problem and sorted it out, or does anyone understand that error and know how I can fix it???

Speed.. Have you come accross this in your TAB theme??

The problem is that there's no value provided for parent_id. The way to fix it would be to locate the code that generates that query, and figure out why the value is missing. I'm not familiar with "Berkley Tabs", so I can't provide additional help.

I have no idea where to find the problem or where to start looking for the code that generates it.

here is the zipped tabs module that I'm using,

Please take a look and see if you can see the problem.

Help would be much appreciated

Thanx

I took a quick look at it. That query is in show_menu.php, function get_child_menu. It's not obvious to me what's causing the problem or how to fix it. I'd have to install the module and play around with it, and I don't have time for that right now.

Thanx for having a look anyway Dave, I hope that now you've pointed out where the problem is, someone else might be able to quickly find a fix for it and let me know.

By the way, putting quotes around the value should suppress that MySQL syntax error, but may only mask (not fix) an underlying error.