[a333]

Originally Posted by Royt

I have installed Commentics , it appears to be working OK but I am getting many SQL errors? See below
I have install the Commentics in a new database separate from the site database.
I cannot find how to link the site database to the Commentics.

I think I have installed as instructiona although a number of posts talk about instruction number 12 I only have 9 points on the integration notes???
Any ideas?

[04-Aug-2012 14:04:37] (shop: 04-Aug-2012 14:04:37) SQL error:
Site : http://www.lusira.co.uk
Remote IP : 80.5.69.112
Logged as :
SQL query : SELECT COUNT(*) FROM xcart_newslists WHERE avail='Y' AND show_as_news='Y' AND lngcode='en' LIMIT 1
Error code : 1146
Description : Table 'lusiraco_commentics.xcart_newslists' doesn't exist
Request URI: //product.php
Backtrace:
/home/lusiraco/public_html/include/func/func.db.php:303
/home/lusiraco/public_html/include/func/func.db.php:203
/home/lusiraco/public_html/include/func/func.db.php:554
/home/lusiraco/public_html/modules/News_Management/func.php:98
/home/lusiraco/public_html/include/func/func.templater.php:606
/home/lusiraco/public_html/include/lib/smarty/internals/core.run_insert_handler.php:51
/home/lusiraco/public_html/var/templates_c/e1a15fdfe6300a6d76ef5a4378bfae40/%%75^75D^75D0653A%%news.tpl.php:7
/home/lusiraco/public_html/include/lib/smarty/Smarty.class.php:1869
/home/lusiraco/public_html/include/templater/templater.php:150
/home/lusiraco/public_html/var/templates_c/e1a15fdfe6300a6d76ef5a4378bfae40/%%86^86E^86EB76EB%%content.tpl.php:103
/home/lusiraco/public_html/include/lib/smarty/Smarty.class.php:1869
/home/lusiraco/public_html/include/templater/templater.php:150
/home/lusiraco/public_html/var/templates_c/e1a15fdfe6300a6d76ef5a4378bfae40/%%5A^5A2^5A22702C%%home.tpl.php:42
/home/lusiraco/public_html/include/lib/smarty/Smarty.class.php:1263
/home/lusiraco/public_html/include/templater/templater.php:82
/home/lusiraco/public_html/include/lib/smarty/Smarty.class.php:1106
/home/lusiraco/public_html/include/func/func.core.php:1206
/home/lusiraco/public_html/product.php:352
/home/lusiraco/public_html/dispatcher.php:160
[04-Aug-2012 14:04:37] (shop: 04-Aug-2012 14:04:37) SQL error:
Site : http://www.lusira.co.uk
Remote IP : 80.5.69.112
Logged as :
SQL query : SELECT clean_url FROM xcart_clean_urls WHERE resource_type = 'C' AND resource_id = '323' LIMIT 1
Error code : 1146
Description : Table 'lusiraco_commentics.xcart_clean_urls' doesn't exist
Request URI: //product.php
Backtrace:
/home/lusiraco/public_html/include/func/func.db.php:303
/home/lusiraco/public_html/include/func/func.db.php:203
/home/lusiraco/public_html/include/func/func.db.php:554
/home/lusiraco/public_html/include/func/func.clean_urls.php:321
/home/lusiraco/public_html/include/func/func.clean_urls.php:339
/home/lusiraco/public_html/include/func/func.templater.php:641
/home/lusiraco/public_html/include/func/func.templater.php:611
/home/lusiraco/public_html/include/lib/smarty/Smarty.class.php:1269
/home/lusiraco/public_html/include/templater/templater.php:82
/home/lusiraco/public_html/include/lib/smarty/Smarty.class.php:1106
/home/lusiraco/public_html/include/func/func.core.php:1206
/home/lusiraco/public_html/product.php:352
/home/lusiraco/public_html/dispatcher.php:160

Originally Posted by PhilJ

You should be using the same database. I will update the install docs later on today, as some steps are no longer required with Commentics v2.1

Ive noticed i have the same problem as this today when my hosting account was getting filled up. The size of the error logs have been running in at a rate of 100mb per day which is filling up my account in the var/log folder.

Because ive already installed my commentics database to a different database, is there anything i can do to correct this, given that it is already installed on my website?

I am reluctant to reinstall commentics again as ive been running it for a while now and dont want to risk messing things up.

Any suggestions would be much appreciated.