Pagina 1 van 1

[spotweb] Installation issues in Windows

Geplaatst: 04 sep 2013, 20:37
door john3voltas
Greetings Spot-Net developers and users.
I'm from P******* and I am trying spotweb for the first time.
This computer runs on Windows 7 x64 and I installed xampp-win32-1.8.3-1-VC11 and the latest zip file for spotweb.
I am following this guide.
I have already created a database called 'spotweb' in mysql but now when I open http://127.0.0.1/spotweb/install.php on my browser I get an error message saying:

Code: Selecteer alles

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\xampp\htdocs\spotweb\lib\dbeng\dbeng_mysql.php on line 27
And then it says:

Code: Selecteer alles

Unable to connect to MySQL server: Access denied for user 'spotweb'@'localhost' (using password: YES)
Please correct the errors in below form and try again
So, when I press the "Verify Database" button nothing happens.
Any ideas?
Thank you all very much.
Cheers

Re: [spotweb] Installation issues in Windows

Geplaatst: 04 sep 2013, 21:21
door Blauwbek
As you might notice you'll have to use pdo_mysql.
You need to select that while entering the db settings.

You dont need anything else, just select the pdo_mysql where you had selected just mysql.
This is because the mysql extension will be removed in time.

Re: [spotweb] Installation issues in Windows

Geplaatst: 04 sep 2013, 22:59
door john3voltas
Hello Blauwbek. Thanks for your reply.
I'm sorry but I can't find anywhere to set the DB to pdo_mysql.
In phpmyadmin the guide just tells me to create a new DB called spotweb. In there I didn't find where to set as mysql or as pdo_mysql.
Then there's the installation.php. The 1st window of installation.php just shows me that database support for DB::pdo_mysql is OK. There is nowhere to set the type of DB in that window.
The next window is where I get stalled and it just has a verify button and a combo box where I can select mysql or postgresql. Nowhere to set the DB to pdo_mysql in there either.
So, what am I missing here? Am I following the wrong guide?
Cheers

Re: [spotweb] Installation issues in Windows

Geplaatst: 05 sep 2013, 18:28
door Blauwbek
You are correct, after checking the installer it seems the 'main' version has no support for pdo_mysql.

The your problem: You might be able to override the 'error' by editing
error_reporting(2147483647);
to
error_reporting(E_ALL & ~E_DEPRECATED);

Suppressing this deprecated notice will not affect you for now as you are only getting a notice to upgrade the mysql code to pdo_mysql, which is currently done in a new version of spotweb.
The php group might however remove the mysql extension whenever they see suitable, so that's why the warning is given.
As long as you don't update your php you'll be fine.

tl;dr: deprecated = notice for the developer to not use something as it might be removed at any moment.
notice can be suppressed by setting error_notice.

Re: [spotweb] Installation issues in Windows

Geplaatst: 08 sep 2013, 18:59
door john3voltas
Hi Blauwbek.
I tried error_reporting(E_ALL & ~E_DEPRECATED); but it didn't work.
This error message only comes up with latest xampp (xampp-win32-1.8.3-1-VC11).
I have now reverted back to an older xampp (xampp-win32-1.8.2-2-VC9) and now I don't get any error message.
Can you please take this to the developer's attention?
Thanks mate.

Re: [spotweb] Installation issues in Windows

Geplaatst: 08 sep 2013, 19:05
door Blauwbek
It'd do that if it wasn't already done in the refactor (rewrite) of spotweb, which isnt ready for full usage yet.
The head developer has decided that the main version of spotweb will no longer be maintained and probably removed when this refactor is done.

Re: [spotweb] Installation issues in Windows

Geplaatst: 08 sep 2013, 19:29
door john3voltas
Oh! Refactor?
But isn't spotweb a new software?
I thought it just had 1 year or something like that.
Wasn't expecting that we would be talking about a refactor already :P.
In that case I will keep using xampp 1.8.2.
But I think we should advise every newcomer about this..."issue".
Cheer

Re: [spotweb] Installation issues in Windows

Geplaatst: 08 sep 2013, 19:38
door Blauwbek
Spotweb was started early 2011 (february i believe).
Since then it has evaluated, getting bits and pieces from a lot of developers.
Because so many people have contributed, it has become a bit of a mess, different code styles, multiple workarounds for stuff, like I said a bit of a mess.
The refactor isn't a full rewrite but it speeds up the program (javascript should be 50% faster!) and it changes the way the program works.

You're right about the deprecated thing.