X-Cart forums

[PhilJ]

Hi Steve, yes, I've been conversing with the author and should have the mod files updated for v2.0 by tomorrow, just not had chance to fully test yet.

[cflsystems]

I updated it on the copy my client wanted to use, just tought you may not know about it. It doesn't seem anything else is affected except for the 3 template files

[a1deano]

Hi Phil

Could you just advise please i download these files two days ago so presume i have the upto date files,, in regards to your instructions
12) FINALLY, in /comments/includes/commentics.php

Replace around line 150...

mysql_close($connection); //close connection to database

However there isn't anything like this, ive pasted part of the code below from line 70 to 151 can you advise please.....Thanks

/************************************************** ************* ERROR REPORTING ************************************************** ******/
cmtx_error_reporting($cmtx_path . "includes/logs/errors.log");
/************************************************** ************************************************** ************************************/


/************************************************** ************* ADMIN DETECTION ************************************************** ******/
$cmtx_is_admin = cmtx_is_administrator(); //detect admin
/************************************************** ************************************************** ************************************/


/************************************************** ************* FORM VALUES ************************************************** **********/
cmtx_load_form_login(); //load login values
cmtx_load_form_defaults(); //load default values
cmtx_load_form_cookie(); //load cookie values
/************************************************** ************************************************** ************************************/


/************************************************** ************* MAINTENANCE (1/2) ************************************************** ****/
if (!cmtx_in_maintenance()) { //if not in maintenance
/************************************************** ************************************************** ************************************/


/************************************************** ************* PAGE ID ************************************************** **************/
$cmtx_page_id = cmtx_validate_page_id(); //validate Page ID
/************************************************** ************************************************** ************************************/


/************************************************** ************* TIME ZONE ************************************************** ************/
@date_default_timezone_set($cmtx_settings->time_zone); //set time zone PHP
@mysql_query("SET time_zone = " . $cmtx_settings->time_zone); //set time zone DB
/************************************************** ************************************************** ************************************/


/************************************************** ************* UNBAN USER ************************************************** ***********/
cmtx_unban_user(); //unban user if requested by admin
/************************************************** ************************************************** ************************************/


/************************************************** ************* LOAD PROCESSOR ************************************************** *******/
require_once $cmtx_path . "includes/app/processor.php"; //load file for form processor
/************************************************** ************************************************** ************************************/


/************************************************** ************* DISPLAY DATA ************************************************** *********/
if ($cmtx_settings->sort_order_parts == "1,2") {
require_once $cmtx_path . "includes/template/comments.php"; //display comments
echo "<div class='cmtx_height_for_divider'></div>"; //display divider
require_once $cmtx_path . "includes/template/form.php"; //display form
} else {
require_once $cmtx_path . "includes/template/form.php"; //display form
echo "<div class='cmtx_height_for_divider'></div>"; //display divider
require_once $cmtx_path . "includes/template/comments.php"; //display comments
}
/************************************************** ************************************************** ************************************/


/************************************************** ************* VIEWERS ************************************************** **************/
if ($cmtx_settings->viewers_enabled) { //if viewers feature is enabled
if (!$cmtx_is_admin) { cmtx_add_viewer(); } //add viewer if not administrator
}
/************************************************** ************************************************** ************************************/


/************************************************** ************* TASK SYSTEM ************************************************** **********/
require_once $cmtx_path . "includes/tasks/tasks.php"; //load task system
/************************************************** ************************************************** ************************************/


/************************************************** ************* MAINTENANCE (2/2) ************************************************** ****/
} //end of if-not-in-maintenance
/************************************************** ************************************************** ************************************/


/************************************************** ************* DATABASE (2/2) ************************************************** *******/
cmtx_reconnect_db(); //reconnect database connection
} //end of is-database-connection-okay
/************************************************** ************************************************** ************************************/


/************************************************** ************* VARIABLES (2/2) ************************************************** ******/
require_once $cmtx_path . "includes/variables/unset_variables.php"; //unset variables for page
/************************************************** ************************************************** ************************************/
?>

[PhilJ]

ok, I've updated the integration files and docs to use Commentics v2.0

Demo

Dean, I would just start afresh with Commentics 2.0... the X-Cart integration is easier, less steps.

[a1deano]

Hi Phil

Thanks for the update all working now except i am getting hundreds of mysql errors since installing seems something to do with clean urls -

SQL query : SELECT clean_url FROM xcart_clean_urls WHERE resource_type = 'P' AND resource_id = '2' LIMIT 1
Error code : 1146
Description : Table 'mysite_mysite.xcart_clean_urls' doesn't exist
Request URI: //product.php
Backtrace:
/home/mysite/public_html/include/func/func.db.php:291
/home/mysite/public_html/include/func/func.db.php:191
/home/mysite/public_html/include/func/func.db.php:542
/home/mysite/public_html/include/func/func.clean_urls.php:320
/home/mysite/public_html/include/func/func.clean_urls.php:339
/home/mysite/public_html/include/func/func.templater.php:694
/home/mysite/public_html/include/func/func.templater.php:615
/home/mysite/public_html/include/lib/smarty/Smarty.class.php:1269
/home/mysite/public_html/include/templater/templater.php:82
/home/mysite/public_html/include/lib/smarty/Smarty.class.php:1106
/home/mysiter/public_html/include/func/func.core.php:1207
/home/mysite/public_html/product.php:344
/home/mysite/public_html/dispatcher.php:156


Ive switched the Commentics off for the time been can you advise please
Thanks Dean

[PhilJ]

Hi Dean, I've just enabled clean URLs on the demo and not noticed any difference, nor any PHP/MySQL errors. It seems to be fine with Clean URLs enabled.

The "mysite_mysite" might be down to the Commentics RSS feeds URL settings, so check those.

[a1deano]

Hi Phil

Thanks for your help "mysite_mysite" is just the name of my database i just changed the name for the forum didn't know if it was a security issue to display the real name...What i did was put Commentics on its own database rather than my xcart database, i am wondering if this could be the issue, might change it over and see what happens....Thanks Dean

[PhilJ]

Ah yes, ideally you want it on the same DB. I'll update the docs to explain that.

[a1deano]

Hi Phil will this work with V4.5.1

Thanks

[PhilJ]

Hi Phil will this work with V4.5.1

Yes, it will work fine