GewGaw
Mon 12th Feb '01, 5:35pm
Dear Wise(wo)men,
I have been working diligently to prepare for the release of v2 of VBB. I am very excited at the possibility to finally dump UBB.
I have run into a problem though. Although I was able to setup the freeware version for testing on the following configuration (FreeBSD, Apache 1.3.12, PHP 4.0.3pl1, MySQL 3.22.23). Once I had upgraded to the following: Apache 1.3.17, PHP 4.0.3pl1, MySQL 3.23.23, GZIP. I am unable to maintain any type of connection to MySQL.
When Accessing current DB:
<!-- Database error in vBulletin:
Invalid SQL:
UPDATE user SET lastvisit=lastactivity WHERE userid=1
mysql error:
mysql error number: 0
Date: Monday 12th of February 2001 05:24:06 PM
Script: /vbb/
Referer:
-->
When attempting to create new DB though install.php:
Warning:
MySQL:
Unable to save result set in
/usr/home/someuser/htdocs/vbb2/admin/db_mysql.php
on line 89
If I continue after a successful reattempt
<!-- Database error in vBulletin Installer: Invalid SQL:
CREATE TABLE announcement (
announcementid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
title CHAR(50) NOT NULL,
userid SMALLINT UNSIGNED NOT NULL,
startdate INT UNSIGNED NOT NULL,
enddate INT UNSIGNED NOT NULL,
pagetext MEDIUMTEXT NOT NULL,
forumid SMALLINT NOT NULL,
PRIMARY KEY(announcementid)
)
mysql error:
mysql error number: 0
Date: Monday 12th of February 2001 05:34:10 PM
Script: /vbb2/admin/install.php?step=4
Referer: http://xxx.xxx.xxx.xxx/vbb2/admin/install.php?step=3
-->
Anyone with some ideas for a direction for me to look in it wqould be great. I may have missed something when searching through the forums here.
Thanks,
GewGaw
I have been working diligently to prepare for the release of v2 of VBB. I am very excited at the possibility to finally dump UBB.
I have run into a problem though. Although I was able to setup the freeware version for testing on the following configuration (FreeBSD, Apache 1.3.12, PHP 4.0.3pl1, MySQL 3.22.23). Once I had upgraded to the following: Apache 1.3.17, PHP 4.0.3pl1, MySQL 3.23.23, GZIP. I am unable to maintain any type of connection to MySQL.
When Accessing current DB:
<!-- Database error in vBulletin:
Invalid SQL:
UPDATE user SET lastvisit=lastactivity WHERE userid=1
mysql error:
mysql error number: 0
Date: Monday 12th of February 2001 05:24:06 PM
Script: /vbb/
Referer:
-->
When attempting to create new DB though install.php:
Warning:
MySQL:
Unable to save result set in
/usr/home/someuser/htdocs/vbb2/admin/db_mysql.php
on line 89
If I continue after a successful reattempt
<!-- Database error in vBulletin Installer: Invalid SQL:
CREATE TABLE announcement (
announcementid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
title CHAR(50) NOT NULL,
userid SMALLINT UNSIGNED NOT NULL,
startdate INT UNSIGNED NOT NULL,
enddate INT UNSIGNED NOT NULL,
pagetext MEDIUMTEXT NOT NULL,
forumid SMALLINT NOT NULL,
PRIMARY KEY(announcementid)
)
mysql error:
mysql error number: 0
Date: Monday 12th of February 2001 05:34:10 PM
Script: /vbb2/admin/install.php?step=4
Referer: http://xxx.xxx.xxx.xxx/vbb2/admin/install.php?step=3
-->
Anyone with some ideas for a direction for me to look in it wqould be great. I may have missed something when searching through the forums here.
Thanks,
GewGaw