Page 1 of 1

How fix news module?

Posted: Tue Mar 06, 2007 8:33 pm
by madelyn
Hello:

I'm using cms with mssql and adodb, but i have the following problems with news module.

Code: Select all

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'cms_module_news'. (severity 16) in C:\Webs\pa\lib\adodb\drivers\adodb-mssql.inc.php on line 710

Warning: mssql_query() [function.mssql-query]: Query failed in C:\Webs\pa\lib\adodb\drivers\adodb-mssql.inc.php on line 710

                     ADOConnection._Execute(
            SELECT 
                 top 3 mn.*, 
                mnc.news_category_name, 
                mnc.long_name, 
    ..., false) % line  891, file: adodb.inc.php
                  ADOConnection.Execute(
            SELECT 
                 top 3 mn.*, 
                mnc.news_category_name, 
                mnc.long_name, 
    ..., false) % line  208, file: adodb-mssql.inc.php
               ADODB_mssql.SelectLimit(
            SELECT 
                mn.*, 
                mnc.news_category_name, 
                mnc.long_name, 
           ..., 3, -1) % line  130, file: action.default.php
            include(C:\Webs\pa\modules\News\action.default.php) % line 1332, file: class.module.inc.php
         CMSModule.DoAction(default, m5, Array[3], -1) % line 1351, file: class.module.inc.php

I need change sql sintax to mssql, but not found the file with this query.