Kanał Rss Kanał Rss
Kanał Atom Kanał Atom

(IP.Downloads - MSSQL) Download File country issue

Hello, If I access a forum locally (RDC into server, pull up on 127.0.0.1) and attempt to download a file from IP.Downloads, I get the following error message: Quote ...

wto, 27 lipiec 2010

IP.Content "Date Entry" Field Type won't accept dates before 1969

Hello! Another issue I noticed with IP.Content is that the system will not take dates before December 31, 1969. Any date I attempt to put in early then that just gets reverted to 1969. ...

wto, 27 lipiec 2010

messengerSearch_mssql.php outdated

The file "admin/applications/members/sql/messengerSearch_mssql.php" is basically an old copy of the mysql one: It still uses MATCH always even if fulltext is disabled (and mssql doesn't ...

wto, 27 lipiec 2010

strict standard errors for adodb_com

The file "ips_kernel\db_lib\mssql_adodb_com.php" is returning a lot of strict standards errors ...

wto, 27 lipiec 2010

Custom profile fields being added as TEXT

New Customer profile fields are being added as TEXT for MSSQL as well and because of that the query returns the error "The data types text and varchar are incompatible in the equal to operator." because there is no CAST AS VARCHAR. The driver ...

wto, 27 lipiec 2010

DB Checker and broken queries

The DB Checker returns a broken "fix query query" if a field is missing in a table. ...

wto, 27 lipiec 2010

IP.Content 2 - Next to impossible to get articles to work

It seems that Articles relies on the ID of the articles database being 4. This is bad, because the 2.0 installer actually inserts the database with the next available ID, not the specific one (since you deliberately unset() the ID). Once that's done, yo ...

wto, 27 lipiec 2010

IP.Gallery New Album Creation Fails

Hello, I attempted to create a new album in IP.Gallery and received the following error: QuoteDate: Tue, 27 Jul 2010 05:44:05 +0000 Error: 3621 - [Microsof ...

wto, 27 lipiec 2010

Template Merge Center Issu

When I run the Template Merge Center on a 3.0.5 skin it just returns a report with no issues. When I go to look at the report it doesn't seem to be checking against a 3.0.5 skin as it just shows Skin Name( > 3.1.1) Where as I ...

śro, 16 czerwiec 2010

3.1.1 Upgrade Errors

\admin\applications\core\setup\versions\upg_31004\mssql_updates.php These lines are causing errors on the upgrade.. I had to comment them out to get past that stage of the upgrade. ...

śro, 16 czerwiec 2010

IP.Content 2.0.1 Upgrade routine

For MySQL, it's just this: update ccs_pages SET page_view_perms=CONCAT(',',page_view_perms,',') WHERE page_view_perms != '*'; (Need to store perms normalized with comma at beginning and end so I can ...

śro, 16 czerwiec 2010

Upgrading from 3.0.5 to 3.1.0 causes DB errors

Error: Column names in each table must be unique. Column name 'pf_search_type' in table 'pfields_data' is specified more than once. MSSQL query error: ALTER TABLE pfields_data ADD pf_search_type VARCHAR(5) NOT NULL DEFAULT ('loose') ...

czw, 10 czerwiec 2010

PM Sent Statistics causes MSSQL error

Statistics Center > PM Sent Statistics Date From: today date To: today Time Scale: Daily Result Sorting: Descending =================================================== Date: Tue, ...

wto, 08 czerwiec 2010

MSSQL Error on IP Lookup

ACP-> Member Validating Queue -> Click an IP Address: =================================================== Date: Mon, 07 Jun 2010 02:10:54 +0000 Error Number: 8120 Error: Column 'admin_logs.id' is invalid in t ...

pon, 07 czerwiec 2010

MSSQL driver folders create uninstallable ACP Apps

In the current MSSQL driver package, board3_1_0_mssql.zip, there are two folders that create confusion/issues: board3_1_0-mssql\admin\applications_addon\other\subscriptions_bak\ ...

pią, 04 czerwiec 2010

IP.Downloads 2.2 Update - Can't add file_cost

Yup, it's that damn column again! It can't be added to an MSSQL table because NOT NULL cannot be specified on a column with no DEFAULT (which makes sense logically- after all, what happens with existing records?!?) Error is: ...

sob, 22 maj 2010

IP.Content 2.0 Update - PHP Parser error

Got this error when hitting the 2.0 step: Parse error: syntax error, unexpected T_VARIABLE in C:\inetpub\wwwroot\ipb31\admin\applications_addon\ips\ccs\s ...

sob, 22 maj 2010

IP.Content 2.0 Update - Invalid syntax for adding multiple fields

Error during IP.Content upgrade, upg_12002: Error: ALTER TABLE ccs_database_fields ADD field_default_value TEXT NULL, ADD field_display_listing INT NOT NULL DEFAULT '1', ADD field_display_display INT NOT NULL DEFAULT ...

sob, 22 maj 2010

Blog 2.2 Upgrade - Attempts to add a column twice

Blog upgrader from 2.1 attempts to add the blog_tag_cloud column more than once, causing fatal error. Date: Fri, 21 May 2010 20:53:59 +0000 Error Number: 2705 Error: [Microsoft][SQL Server Native Client 10 ...

pią, 21 maj 2010

3.1.0 upgrade routine

It doesn't match MySQL. For instance, it doesn't have this (or the equivalent) if ( trim($ids) ) { $SQL[] = "DELETE FROM skin_templates WHERE template_set_id IN (" . $ids . ");"; $SQL[] = "DELETE FR ...

wto, 04 maj 2010
1 2 3 4 >>