SQL Errors during install

NoTx · June 2nd, 2006, 09:38 PM

Hello, I recieved these errors in step three of the install. I am running PHP 5, MySQL 5 and Windows 2003/IIS6.

Step 3: MySQL error reported: [INSERT INTO pja_categories VALUES (1,'Main','',1,'no',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'2',0,0,0,0,0,0,0,'no', 0, '', 'no', NULL, NULL,'','','');]
Result: Out of range value adjusted for column 'thumbnail' at row 1
Database: pj_db

Step 3: MySQL error reported: [INSERT INTO pja_categories VALUES (2,'A Category','Products of a particular type',1,'yes',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,'no', 0, '', 'no', NULL, NULL,'','','');]
Result: Out of range value adjusted for column 'thumbnail' at row 1
Database: pj_db

Step 3: MySQL error reported: [INSERT INTO pja_settings VALUES (179,'GMT Offset', 'gmtoffset', 'If you are running VB and want the server to display the time as an offset of GMT (for example, to the timezone where your server is located), enter the offset here.', '0', 25, 1)]
Result: Data too long for column 'description' at row 1
Database: pj_db

Step 3: MySQL error reported: [INSERT INTO pja_settings VALUES (216, 'WorldPay Installation ID', 'wp_instid', 'The Install ID that is generated by the WorldPay CMS for the subscription callback.
You must set your callback url to point to your payment.php script', '', 8, 12)]
Result: Data too long for column 'description' at row 1
Database: pj_db

Step 3: MySQL error reported: [CREATE TABLE zipData (zipcode varchar(5) NOT NULL default '', ZipCodeType char(3) NOT NULL default '', City varchar(128) NOT NULL default '', CityType char(3) NOT NULL default '', State varchar(64) NOT NULL default '', StateCode varchar(5) NOT NULL default '', AreaCode int(5) NOT NULL default '0', lon varchar(8) NOT NULL default '', lat varchar(8) NOT NULL default '') TYPE=MyISAM]
Result: Table 'zipdata' already exists
Database: pj_db

Step 3: MySQL error reported: [INSERT INTO pja_cache VALUES (1,'',null,null,null,null,null,null,null)]
Result: Out of range value adjusted for column 'timestamp' at row 1
Database: pj_db

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

I then tried to continue, as it recomended, and after filling out step four, I recieved this error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using password: NO) in D:\Plane Jumpers\pjc\install.php on line 1031
I cannot connect to the Members database.

Chuck S · June 2nd, 2006, 09:50 PM

Is this your issue? This thread might help

Mysql 5 Compatibility

NoTx · June 2nd, 2006, 10:58 PM

Well, I received less errors....

First:

Step 3: MySQL error reported: [CREATE TABLE zipData (zipcode varchar(5) NOT NULL default '', ZipCodeType char(3) NOT NULL default '', City varchar(128) NOT NULL default '', CityType char(3) NOT NULL default '', State varchar(64) NOT NULL default '', StateCode varchar(5) NOT NULL default '', AreaCode int(5) NOT NULL default '0', lon varchar(8) NOT NULL default '', lat varchar(8) NOT NULL default '') TYPE=MyISAM]
Result: Table 'zipdata' already exists
Database: pj_db

And second (at the very end when trying to propagate VB tables and link the db I think).

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using password: NO) in D:\Plane Jumpers\pjc\install.php on line 1031
I cannot connect to the Members database.

Chuck S · June 3rd, 2006, 10:30 AM

Well duplicate mysql errors are no biggy means you they exist

As far as the mysql_connect issue just check the info to connect to the members database it would appear incorrect

NoTx · June 3rd, 2006, 12:36 PM

Who is the user listed here that is not allowed?

"Access denied for user 'ODBC'@'localhost' (using password: NO)"

I know the primary mysql user is correct.

Chuck S · June 3rd, 2006, 01:01 PM

I suggest you check your vbulletin config.php file for the access information to connect to the vbulletin user database. The error your posting states you have entered this incorrectly.

Recheck the host database user and password variables.

NoTx · June 3rd, 2006, 01:42 PM

I cleared out the board and vbportal and reinstalled, copying and pasting from vbulletins 3.5's config file. Prior to this I changed to MySQL 4.1 instead of 5.

I am still getting this error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using password: NO) in D:\Plane Jumpers\cl\install.php on line 1031
I cannot connect to the Members database.

I have no user anywhere that is called 'ODBC'.

THis appears to be the query that is running when it stops:

$query[] = "CREATE TABLE {$pp_db_prefix}bids ( id int(2) NOT NULL auto_increment, ad_id int(12) NOT NULL default '0', user_id int(12) NOT NULL default '0', username varchar(128) NOT NULL default '', bid float(12,2) NOT NULL default '0.00', maxbid float(12,2) NOT NULL default '0.00', bid_date int(12) NOT NULL default '0', bid_ip varchar(16) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM";

Oh, and when I switched to MySQL 4.1, the other error went away.

NoTx · June 3rd, 2006, 01:51 PM

Blank Post (my error

) (Ment to post on a different board...)

BUt I still don't understand where this user OBDC is comming from... especially being that would be for like Access or some such... and I only have MySQL.

NoTx · June 3rd, 2006, 05:22 PM

AM I doing something wrong here that is causing it?

I am leaving thses blank on the first input screen:

User Database Host (enter same info as above if not integrating with a third party forum)
User Database Name
User Database User
User Database Password

I am filling out the above, but leaving these blank, as I took the directions to mean...

Is this incorrect? If so, what should be here? I am integrating with the current version of VBulletin.

NoTx · June 3rd, 2006, 05:53 PM

Okay, I tried filling that in and got all the way to the end. I now get this error:

Parse error: parse error, unexpected T_STRING in D:\Plane Jumpers\cl\config-intc.php on line 16

I am running Vbulletin 3.5 and VBPortal 3.

My settings are in the attachment.

Where am I going wrong?

Chuck S · June 3rd, 2006, 06:12 PM

We need to backup here.

If you still are getting the members database can not be connected to you need to go back to the config section of install and make sure in the user database portion of the Photopost config you are entering your correct database information for your vbulletin install.

This is the error I see by your post.

NoTx · June 3rd, 2006, 06:58 PM

Quote:

Originally Posted by Chuck S

We need to backup here.

If you still are getting the members database can not be connected to you need to go back to the config section of install and make sure in the user database portion of the Photopost config you are entering your correct database information for your vbulletin install.

This is the error I see by your post.

I am no longer getting that error. In fact I have the install going smoothly. When I try and log in or go to the index.php page I get this error:

"Parse error: parse error, unexpected T_STRING in D:\Plane Jumpers\cl\config-intc.php on line 16"

Chuck S · June 3rd, 2006, 08:07 PM

Try uploading a clean config-intc.php file as that one is corrupt.

NoTx · June 4th, 2006, 01:55 AM

I reinstalled the file, re-ran through the install. It now loads, however it does not integrate to VBulletin or Vbportal at all. Instead I get this error when trying to turn on the VbPortal administration:

Warning: fopen(config-intc.php) [function.fopen]: failed to open stream: Permission denied in D:\Plane Jumpers\cl\adm-misc.php on line 1367

Warning: fwrite(): supplied argument is not a valid stream resource in D:\Plane Jumpers\cl\adm-misc.php on line 1368

Warning: fclose(): supplied argument is not a valid stream resource in D:\Plane Jumpers\cl\adm-misc.php on line 1369

Configuration updated!

Click here if you do not want to wait any longer
(or if your browser does not automatically forward you)

So... would your installation service install it with the integration? Getting more than a might frustrated.

Chuck S · June 4th, 2006, 10:40 AM

You need to make sure on install that both config files are 666 READ WRITE. Basically on the last step of install we can not write the variables to config-intc.php

NoTx · June 4th, 2006, 02:33 PM

oK, beyond the other errors.

My current error is:

Warning: require(mainfile.php) [function.require]: failed to open stream: No such file or directory in D:\Plane Jumpers\cl\header-inc.php on line 255

Fatal error: require() [function.require]: Failed opening required 'mainfile.php' (include_path='.;C:\php5\pear') in D:\Plane Jumpers\cl\header-inc.php on line 255

When I try going to index.php.

NoTx · June 4th, 2006, 03:08 PM

It was the integration with VBportal. I turned it off and manually added it to VBportals main menu. Works now. Thanks!