I saw the same error when I installed the previous version of Open PHPNuke. If you change the SQL query for position1 FLOAT(0,0) to poisition1 FLOAT (2,2), then the SQL query will work. But, a few queries have the same issue and need to be changed. After all of the changes, the site will come up, but it seems like it does not work properly because of the changes to FLOAT (0,0) to the new FLOAT (*,*), with * being a number greater than 0.

This is what I get when i try to open the page of OPN...

It made the tables and everything, when I look into the mysql-page of the phpmyadmin site...

--------------------------------------------------------------------------------
WARNING [8] Only variables should be assigned by reference
FOUND IN [K:Xamppxampphtdocsopnclasssqladodbdriversadodb-mysql.inc.php]
FOUND AT 629

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Only variables should be assigned by reference
FOUND IN [K:Xamppxampphtdocsopnclasssqladodbdriversadodb-mysql.inc.php]
FOUND AT 629

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Only variables should be assigned by reference
FOUND IN [K:Xamppxampphtdocsopnclasssqladodbdriversadodb-mysql.inc.php]
FOUND AT 629

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Only variables should be assigned by reference
FOUND IN [K:Xamppxampphtdocsopnclasssqladodbdriversadodb-mysql.inc.php]
FOUND AT 629

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Only variables should be assigned by reference
FOUND IN [K:Xamppxampphtdocsopnclasssqladodbdriversadodb-mysql.inc.php]
FOUND AT 629

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Only variables should be assigned by reference
FOUND IN [K:Xamppxampphtdocsopnclasssqladodbdriversadodb-mysql.inc.php]
FOUND AT 629

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Only variables should be assigned by reference
FOUND IN [K:Xamppxampphtdocsopnclasssqladodbdriversadodb-mysql.inc.php]
FOUND AT 629

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Only variables should be assigned by reference
FOUND IN [K:Xamppxampphtdocsopnclasssqladodbdriversadodb-mysql.inc.php]
FOUND AT 629

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Only variables should be assigned by reference
FOUND IN [K:Xamppxampphtdocsopnclasssqladodbdriversadodb-mysql.inc.php]
FOUND AT 629

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Only variables should be assigned by reference
FOUND IN [K:Xamppxampphtdocsopnclasssqladodbdriversadodb-mysql.inc.php]
FOUND AT 629

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Only variables should be assigned by reference
FOUND IN [K:Xamppxampphtdocsopnclasssqladodbdriversadodb-mysql.inc.php]
FOUND AT 629

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Only variables should be assigned by reference
FOUND IN [K:Xamppxampphtdocsopnclasssqladodbdriversadodb-mysql.inc.php]
FOUND AT 629

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Only variables should be assigned by reference
FOUND IN [K:Xamppxampphtdocsopnclasssqladodbdriversadodb-mysql.inc.php]
FOUND AT 629

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Undefined index: opn_url
FOUND IN [K:Xamppxampphtdocsopnmaster.php]
FOUND AT 329

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Undefined index: opn_url
FOUND IN [K:Xamppxampphtdocsopnmaster.php]
FOUND AT 730

Notice: Undefined index: encodeurl in K:Xamppxampphtdocsopnclassclass.errorhandler.php on line 43

Notice: Undefined index: opn_use_coredevdebug in K:Xamppxampphtdocsopnclassclass.errorhandler.php on line 53

Notice: Undefined index: opn_error_log in K:Xamppxampphtdocsopnclassclass.errorhandler.php on line 71

Fatal error: mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1] in EXECUTE("SELECT COUNT(error_id) AS counter FROM ") in K:Xamppxampphtdocsopnincludeopndb-errorhandler.php on line 217

anonymous wrote at January 29, 2006 at 13:09:52 clock the following:

Now I got this on screen 7/8

Notice: Undefined index: opn_charset_encoding in K:Xamppxampphtdocsopnmaster.php on line 331

and

Create tables / index / data Now the tables / index / data of OPN will be created.


Fatal error: mysql error: [1439: Display width out of range for column 'position1' (max = 255)] in EXECUTE("CREATE TABLE opn_opn_middlebox (sbid INT (10) DEFAULT '0' NOT NULL, sbtype TEXT NOT NULL, sbpath TEXT NOT NULL, visible INT (1) DEFAULT '0' NOT NULL, seclevel INT (10) DEFAULT '0' NOT NULL, category INT (10) DEFAULT '0' NOT NULL, side INT (1) DEFAULT '0' NOT NULL, position1 FLOAT (0,0) DEFAULT '0' NOT NULL, options BLOB NOT NULL, anker INT (4) DEFAULT '0' NOT NULL, themegroup INT (10) DEFAULT '0' NOT NULL, width INT (10) DEFAULT '0' NOT NULL, module VARCHAR (250) DEFAULT '' NOT NULL, info_text VARCHAR (250) DEFAULT '' NOT NULL, PRIMARY KEY (sbid)) ") in K:Xamppxampphtdocsopnincludeopndb-errorhandler.php on line 217

I don't get it...

I could solve the problem with the master.php-file... so it doesn't give me that error anymore...

I putt this in...

if (!isset($opnConfig['opn_charset_encoding'])) {
$opnConfig['opn_charset_encoding'] = 'iso-8859-1';

The only thing remaining is this error...

Fatal error: mysql error: [1439: Display width out of range for column 'position1' (max = 255)] in EXECUTE("CREATE TABLE opn_opn_middlebox (sbid INT (10) DEFAULT '0' NOT NULL, sbtype TEXT NOT NULL, sbpath TEXT NOT NULL, visible INT (1) DEFAULT '0' NOT NULL, seclevel INT (10) DEFAULT '0' NOT NULL, category INT (10) DEFAULT '0' NOT NULL, side INT (1) DEFAULT '0' NOT NULL, position1 FLOAT (0,0) DEFAULT '0' NOT NULL, options BLOB NOT NULL, anker INT (4) DEFAULT '0' NOT NULL, themegroup INT (10) DEFAULT '0' NOT NULL, width INT (10) DEFAULT '0' NOT NULL, module VARCHAR (250) DEFAULT '' NOT NULL, info_text VARCHAR (250) DEFAULT '' NOT NULL, PRIMARY KEY (sbid)) ") in K:Xamppxampphtdocsopnincludeopndb-errorhandler.php on line 217

What could be the problem?

Thanx in advance for helping...

Now I got this on screen 7/8

Notice: Undefined index: opn_charset_encoding in K:Xamppxampphtdocsopnmaster.php on line 331

and

Create tables / index / data Now the tables / index / data of OPN will be created.


Fatal error: mysql error: [1439: Display width out of range for column 'position1' (max = 255)] in EXECUTE("CREATE TABLE opn_opn_middlebox (sbid INT (10) DEFAULT '0' NOT NULL, sbtype TEXT NOT NULL, sbpath TEXT NOT NULL, visible INT (1) DEFAULT '0' NOT NULL, seclevel INT (10) DEFAULT '0' NOT NULL, category INT (10) DEFAULT '0' NOT NULL, side INT (1) DEFAULT '0' NOT NULL, position1 FLOAT (0,0) DEFAULT '0' NOT NULL, options BLOB NOT NULL, anker INT (4) DEFAULT '0' NOT NULL, themegroup INT (10) DEFAULT '0' NOT NULL, width INT (10) DEFAULT '0' NOT NULL, module VARCHAR (250) DEFAULT '' NOT NULL, info_text VARCHAR (250) DEFAULT '' NOT NULL, PRIMARY KEY (sbid)) ") in K:Xamppxampphtdocsopnincludeopndb-errorhandler.php on line 217

I don't get it...

Yes i did create an empty database...
it was called "opn"...
The path I used was also "opn"...
maybe I putt in the wrong path here?

But now i'm installing apache, PHP and MySQL seperately and I am trying to get it to work with this kinf of setup...
using apache 2.0.5, PHP 5.1.2 and MySQL 5.0.18...

thank you for your reply,

I'll post back if I get it to work...

Kindest regards

Stijn

Hi,
usually XAMPP from apachefriends should work.
you did create an empty database before you install?
What path do you use?

This is the package I used...
Coukld there be the problem?

I've looked in the windows error-report and it showed me a file called php5ts.dll... i guess this is the problem?

ApacheFriends XAMPP (basic package) version 1.5.1
+ Apache 2.2.0
+ MySQL 5.0.18
+ PHP 5.1.1 + PHP 4.4.1-pl1 + PEAR
+ eAccelerator 0.9.4-rc1
+ PHP-Switch win32 1.0 (from Apachefriends, use the "php-switch.bat")
+ XAMPP Control Version 2.1 from www.nat32.com     
+ XAMPP Security 1.0     
+ SQLite 2.8.15
+ OpenSSL 0.9.8a
+ phpMyAdmin 2.7.0 pl1
+ ADOdb 4.68
+ FPDF 1.5.3
+ Mercury Mail Transport System v4.01b
+ FileZilla FTP Server 0.9.11
+ Webalizer 2.01-10
+ Zend Optimizer 2.6.0

Hello,

I'm trying to install OPN for a whole day now
When I open the install.php file all runs well.
I've got my MySQL DB, physical path everything correct... but when it comes to creating the admin account it gives me an error.

when I click on the write/create tables, it spits out an apache error en the next screen is an "cannot find page"-file...

I used Xampp to install everything... followed the flash tutorial...

Got Win XP, latest Xampp,...

Anyone an idea?