category parent 9.9(fix)

[peppolone]

how i solved category-parent problem in last svn, essential for many mods (menudigglike,submitdigglike)
open config.php on line 125 add category_parent into the select

		$the_cats = $db->get_results("select category_parent, category_id, category__auto_id, lft, rgt, category_name, category_safe_name, category_lang, category_desc, category_keywords from ".table_categories." ORDER BY lft ASC;");

do the same for admin_categories.php on line 40
remember to delete all files from cache folder
if u solve tnx me

[skins4webs]

Have not tried it but good job if it works!

[xiesi]

conifg.php on line 125?

the code on line 125 is:

// start summarization and caching of mysql data

[xiesi]

i got error:

Warning: Unknown column 'category_desc' in 'field list' in E:\wwwroot\qelele\wwwroot\libs\db.php on line 233

Warning: Invalid argument supplied for foreach() in E:\wwwroot\qelele\wwwroot\libs\html1.php on line 14

Warning: Invalid argument supplied for foreach() in E:\wwwroot\qelele\wwwroot\libs\html1.php on line 174

Warning: Invalid argument supplied for foreach() in E:\wwwroot\qelele\wwwroot\libs\dbtree.php on line 73

Warning: Invalid argument supplied for foreach() in E:\wwwroot\qelele\wwwroot\libs\dbtree.php on line 194

Warning: Invalid argument supplied for foreach() in E:\wwwroot\qelele\wwwroot\libs\dbtree.php on line 194

Warning: Invalid argument supplied for foreach() in E:\wwwroot\qelele\wwwroot\libs\dbtree.php on line 73

Warning: Invalid argument supplied for foreach() in E:\wwwroot\qelele\wwwroot\libs\dbtree.php on line 194

Warning: Invalid argument supplied for foreach() in E:\wwwroot\qelele\wwwroot\libs\dbtree.php on line 194

Warning: Invalid argument supplied for foreach() in E:\wwwroot\qelele\wwwroot\libs\dbtree.php on line 73

Warning: Invalid argument supplied for foreach() in E:\wwwroot\qelele\wwwroot\libs\dbtree.php on line 194

Warning: Invalid argument supplied for foreach() in E:\wwwroot\qelele\wwwroot\libs\dbtree.php on line 194

[xiesi]

i add category_parent into the select in conifg.php

$the_cats = $db->get_results("select category_parent, category_id, category_name, category_safe_name, category_lang from ".table_categories.";");


modify the admin_category.php to:

$the_cats = $db->get_results("select category_parent, category_id, category__auto_id, lft, rgt, category_name, category_safe_name, category_lang, category_desc, category_keywords from ".table_categories." ORDER BY lft ASC;");

is it correct?

[xenfra]

I have try too and give me

Warning: Unknown column 'category_desc' in 'field list' in /var/www/vhosts/xenfra.com/httpdocs/libs/db.php on line 233

Warning: Invalid argument supplied for foreach() in /var/www/vhosts/xenfra.com/httpdocs/libs/html1.php on line 14

Warning: Invalid argument supplied for foreach() in /var/www/vhosts/xenfra.com/httpdocs/libs/html1.php on line 171

Warning: Invalid argument supplied for foreach() in /var/www/vhosts/xenfra.com/httpdocs/libs/dbtree.php on line 76
There is a problem with the categories table. Error CA:001.

[peppolone]

$the_cats need to be the same in both files. i don't know what is your version, but in your config.php it is only a part...
Try to make the function in your config.php equal to admin_categories.php
$the_cats = $db->get_results("select category_parent, category_id, category__auto_id, lft, rgt, category_name, category_safe_name, category_lang, category_desc, category_keywords from ".table_categories." ORDER BY lft ASC;");

[xenfra]

I wrong something before

[xiesi]

i used 9.9.0.
I just change $the_cats to be the same in both files.but i got the error:

Warning: Unknown column 'category_desc' in 'field list' in E:\wwwroot\qelele\wwwroot\libs\db.php on line 233

Warning: Invalid argument supplied for foreach() in E:\wwwroot\qelele\wwwroot\libs\html1.php on line 14

Warning: Invalid argument supplied for foreach() in E:\wwwroot\qelele\wwwroot\libs\html1.php on line 174

Warning: Invalid argument supplied for foreach() in E:\wwwroot\qelele\wwwroot\libs\dbtree.php on line 73

Warning: Invalid argument supplied for foreach() in E:\wwwroot\qelele\wwwroot\libs\dbtree.php on line 194

[xenfra]

Are you sure? yesterday I had same error and I try to check another time and upload the 2 files