Webmastersite.net
Register Log In

Unable to Install - Duplicate definition
mysql.php and mysqli.php are both installed...

Comments on Unable to Install - Duplicate definition

lwoodsinc
Member

Usergroup: Member
Joined: Jul 23, 2007

Total Topics: 7
Total Comments: 14
Posted Jul 23, 2007 - 7:04 PM:

The installation process installs both the mysql.php and the mysqli.php modules and these both have the same functions defined within them. PHP returns a "Duplicate definition." The installation "looks" like it it O.K. but no database updates occur.

Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Jul 23, 2007 - 9:15 PM:

It's impossible to use both at the same time, so that isn't the problem unless you've written your own custom config.php file. Please provide the debug info of the pages where you see a problem: www.wsnforum.com/wsnmanual/...icles/mysql-errors-66.html
lwoodsinc
Member

Usergroup: Member
Joined: Jul 23, 2007

Total Topics: 7
Total Comments: 14
Posted Jul 24, 2007 - 7:49 AM:

Don't know what to tell you but the impossible continues to happen! I start with an empty mySQL database and a virgin install unzipped directly from the zip file that was sent to me. The complete "wsnforum" folder is uploaded to the site...although I renamed it to "forum." When I run the setup I get the attached error (clipped as a jpg for you). The error is:

Fatal error: Cannot redeclare mysqlquotefields() in /home/itslovewhen/forum/databases/mysqli.php on line 90

which is caused because both the mysql.php AND the mysqli.php files are loaded.

I have also attached the config.php that was generated if you need to look at it. I have blanked out the mySQL IP address, userid, password. Also, I have left the site as it was created. My experience is that it looks like everything is O.K. but when in Admin mode it will not save any changed I make...although I get no errors!

Attached Files:
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Jul 24, 2007 - 6:19 PM:

The config says you're using mysqli only, so I'd guess mysqli.php is being called twice somewhere for some reason. You have 5.1.17-beta, which should work, unless the -beta messes up version detection somewhere.

You can fill out the form for free installation: http://www.wsnforum.com/index.php?section=installation

It would be easier for me to figure it out with direct access.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Jul 24, 2007 - 9:13 PM:

Looks like config.php was being included twice. I believe 2.0.24 has fixed it.
lwoodsinc
Member

Usergroup: Member
Joined: Jul 23, 2007

Total Topics: 7
Total Comments: 14
Posted Jul 25, 2007 - 8:44 AM:

Paul,

The new code installed correctly, but database updates are being ignored. I logged in as administrator, went to System Configuration and changed the title of the site from "WSN Forum" to "Forum." Clicked "Update Settings" and got the "Settings have been updated" page. BUT, it didn't update the setting! I tried other settings. Same story. But, also no error message.

????????????

If you want to check out the page, how do I contact you with login/password? I am not going to put this info on the public site!
lwoodsinc
Member

Usergroup: Member
Joined: Jul 23, 2007

Total Topics: 7
Total Comments: 14
Posted Jul 25, 2007 - 10:25 AM:

Paul,

Latest...FYI...
I had initially loaded WSN Forum on a Linux server running PHP 5.0.4 as a test site. No problem. Then I moved the code to a production Linux server---the present one with problems---and it is running PHP 5.2.3. In both cases the setup detected mysqli and defined that as the access method in config.php. The 5.2.3 site is the one that seems to ignore updates to the database. In order to try to narrow down the problem, I went into the new site scripts and manually changed config.php from "mysqli" to "mysql" and now the new site does the updates correctly. I would not swear that the PHP version is the problem since the new site also has additional/different PHP extensions, but there DOES seem to be a problem somewhere in this newest PHP install. BTW, the hosting is on a commercial site, not something that would be all patched up.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Jul 26, 2007 - 2:09 AM:

I'm running PHP 5.2.3 on all my sites, but with MySQL 4.1.21. My config.phps specify mysqli and it gives me no problems. This support forum, for example, has those specs. It's possible that this mysql beta version you use has changed something which affects php's mysqli extension (but not its older, more basic mysql extension). Since it's a beta one might expect random bugs.

The only way I know of for mysql updates to fail (other than a mysql bug) is if the mysql user hasn't been given permission to do updates.

BTW, the hosting is on a commercial site, not something that would be all patched up.

Well the hosting is using a beta version of MySQL, as you can see at your servertest.php. It's not even the latest beta, 5.1.20 is what's currently in beta. I'd suppose they're probably unaware, let them know what version they're running.

how do I contact you with login/password?

http://www.wsnforum.com/index.php?section=support
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.