Unable to Install - Duplicate definition: WSN Support

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

Version:

Unable to Install - Duplicate definition

lwoodsinc
Member

Usergroup: Member
Joined: Jul 23, 2007
Total Topics: 7
Total Posts: 14

Posted 07/23/07 - 04:04 PM:	#1
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
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 6022

Posted 07/23/07 - 06:15 PM:	#2
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: http://www.wsnforum.com/wsnmanual/articles/mysql-...
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

lwoodsinc
Member

Usergroup: Member
Joined: Jul 23, 2007
Total Topics: 7
Total Posts: 14

Posted 07/24/07 - 04:49 AM:	#3
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: error.jpg (29 KB, 23 downloads) config.php (2 KB, 35 downloads)

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 6022

Posted 07/24/07 - 03:19 PM:	#4
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. Edited by Paul on 07/24/07 - 03:26 PM
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 6022

Posted 07/24/07 - 06:13 PM:	#5
Looks like config.php was being included twice. I believe 2.0.24 has fixed it.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

lwoodsinc
Member

Usergroup: Member
Joined: Jul 23, 2007
Total Topics: 7
Total Posts: 14

Posted 07/25/07 - 05:44 AM:	#6
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 Posts: 14

Posted 07/25/07 - 07:25 AM:	#7
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
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 6022

Posted 07/25/07 - 11:09 PM:	#8
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 Edited by Paul on 07/25/07 - 11:18 PM
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

You don't have permission to post.