smf IIS and MySQL issues

  • tgray96
  • Novice
  • Novice
  • tgray96
  • Posts: 27
  • Loc: Rising Sun Indiana

Post 3+ Months Ago

ok so installed MySQL, but i cant create user accounts and it wont let me use root on the SMF installer

ok not worried about that now, i cannot create a MySQL user via the MySQL Workbech

Create User:
user: smf
password:xxx
password:xxx
limit connectivity to hosts matching: localhost

After clicking create i get error:

Unhandled Exception
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Posts: 9089
  • Loc: Seattle, WA & Phoenix, AZ

Post 3+ Months Ago

Could you provide a bit more information? What type of server are you running? Windows? Linux?

How come you cannot create any MySQL users? Did it provide you some sort of error message? I know you installed MySQL, but are you sure MySQL is actually running?
  • tgray96
  • Novice
  • Novice
  • tgray96
  • Posts: 27
  • Loc: Rising Sun Indiana

Post 3+ Months Ago

according to the MySQL workbench its running
Error: Unhandled Exception:Error adding account smf@localhost:

IIS 7, along with php

after noticing the web hosting forum i realize i should've put it there..... sorry :)... Thats running on Windows server 2008 R2 64bit
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Posts: 9089
  • Loc: Seattle, WA & Phoenix, AZ

Post 3+ Months Ago

Do you have phpMyAdmin installed? If not you may want to install that. I have heard reports that there could be a bug with the GUI tools (if that is how you are trying to do it) and that some people have reported that they can get around the problem by using phpMyAdmin and adding your user there.
  • tgray96
  • Novice
  • Novice
  • tgray96
  • Posts: 27
  • Loc: Rising Sun Indiana

Post 3+ Months Ago

i have phpmyadmin installed, but i cant login :(....

i have tried root
and root@localhost

neither work
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Posts: 9089
  • Loc: Seattle, WA & Phoenix, AZ

Post 3+ Months Ago

What is the error message you are getting when you try to login via phpMyAdmin? Just not authorized?
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Posts: 9089
  • Loc: Seattle, WA & Phoenix, AZ

Post 3+ Months Ago

Also quick question, I noticed you are using a 64 bit system. Did you install the 32 bit version or 64 bit version of MySQL? Could you tell me exactly what version you installed, and if you installed it as part of a greater package, or all separately by itself.
  • tgray96
  • Novice
  • Novice
  • tgray96
  • Posts: 27
  • Loc: Rising Sun Indiana

Post 3+ Months Ago

it is a 32 bit..... maybe thats my problem......... just in case not heres the error: #1045 Cannot log in to the MySQL server
  • tgray96
  • Novice
  • Novice
  • tgray96
  • Posts: 27
  • Loc: Rising Sun Indiana

Post 3+ Months Ago

Its MySQL 5.5 and it was installed by itself...
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Posts: 9089
  • Loc: Seattle, WA & Phoenix, AZ

Post 3+ Months Ago

Also make sure in your phpMyAdmin config file you have set the user to root and the password correctly. You do know the MySQL root's password right? Meaning you set this up at one point during the install of MySQL?
  • tgray96
  • Novice
  • Novice
  • tgray96
  • Posts: 27
  • Loc: Rising Sun Indiana

Post 3+ Months Ago

yes....... I am going to reinstall MySQL in 64 bit.... but I'll check the phpmyadmin folder as well... Thanks!
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Posts: 9089
  • Loc: Seattle, WA & Phoenix, AZ

Post 3+ Months Ago

Okay let us know what you figure out after you re-install :)
  • tgray96
  • Novice
  • Novice
  • tgray96
  • Posts: 27
  • Loc: Rising Sun Indiana

Post 3+ Months Ago

Alright... Thanks
  • tgray96
  • Novice
  • Novice
  • tgray96
  • Posts: 27
  • Loc: Rising Sun Indiana

Post 3+ Months Ago

alright getting this error from simple machine forums php web-based installer:

Some of the queries were not executed properly. This could be caused by an unsupported (development or old) version of MySQL.

Technical information about the queries:
Line #563: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) /*!40102 NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP */,' at line 3
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Posts: 9089
  • Loc: Seattle, WA & Phoenix, AZ

Post 3+ Months Ago

So did you get further than before? Did the other problem go away and you were able to create a MySQL user and password? Maybe try and older version of MySQL:

http://dev.mysql.com/downloads/mysql/5.1.html
  • tgray96
  • Novice
  • Novice
  • tgray96
  • Posts: 27
  • Loc: Rising Sun Indiana

Post 3+ Months Ago

i didn't even try to create a user, but it allows me to use the root user
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Posts: 9089
  • Loc: Seattle, WA & Phoenix, AZ

Post 3+ Months Ago

I would highly recommend you do not use the root user, and you actually create another username and password.
  • tgray96
  • Novice
  • Novice
  • tgray96
  • Posts: 27
  • Loc: Rising Sun Indiana

Post 3+ Months Ago

ok added user, now i get this error when installing smf via web install:


Some of the queries were not executed properly. This could be caused by an unsupported (development or old) version of MySQL.

Technical information about the queries:
Line #563: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) /*!40102 NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP */,' at line 3
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Posts: 9089
  • Loc: Seattle, WA & Phoenix, AZ

Post 3+ Months Ago

Did you try the advice in my previous post and also downgrade the version of MySQL you are using? It appears the way SMF is creating their queries could be causing problems with the newer version of MySQL.

MySQL broke compatibility with older scripts since version 5.5, as it doesn't allow anymore the usage of TYPE in the syntax, even as deprecated. I do not believe they have fixed that in SMF yet, so downgrading your version of MySQL to the 5.1 version will hopefully fix that problem.
  • tgray96
  • Novice
  • Novice
  • tgray96
  • Posts: 27
  • Loc: Rising Sun Indiana

Post 3+ Months Ago

i just downloaded it and removed "new" version, installed 5.1, ran smf setup again:


Some of the queries were not executed properly. This could be caused by an unsupported (development or old) version of MySQL.

Technical information about the queries:
Line #563: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) /*!40102 NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP */,' at line 3
  • tgray96
  • Novice
  • Novice
  • tgray96
  • Posts: 27
  • Loc: Rising Sun Indiana

Post 3+ Months Ago

still nothing
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Posts: 9089
  • Loc: Seattle, WA & Phoenix, AZ

Post 3+ Months Ago

Are you absolutely positive you are running MySQL version 5.1? I have this hunch that for some reason you are still running version 5.5. Can you verify what version of MySQL is actually running.
  • tgray96
  • Novice
  • Novice
  • tgray96
  • Posts: 27
  • Loc: Rising Sun Indiana

Post 3+ Months Ago

MySQL
Server: localhost via TCP/IP
Server version: 5.5.10
Protocol version: 10
User: root@localhost
MySQL charset: UTF-8 Unicode (utf8)

Web server
Microsoft-IIS/7.5
MySQL client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $
PHP extension: mysql

according to phpmyadmin i am, i uninstalled it, how should i go about removing it?
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Posts: 9089
  • Loc: Seattle, WA & Phoenix, AZ

Post 3+ Months Ago

Try your Add/Remove programs in your control panel, and make sure that you stop and restart MySQL after you install the other MySQL version. If in doubt, maybe reboot the server. Once you get that to say server version 5.1.56, then I think your other problem will go away.
  • tgray96
  • Novice
  • Novice
  • tgray96
  • Posts: 27
  • Loc: Rising Sun Indiana

Post 3+ Months Ago

alright, its working but i am having an issue, none of my images are working, i had this exact problem on my shared host...... any ideas?
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Posts: 9089
  • Loc: Seattle, WA & Phoenix, AZ

Post 3+ Months Ago

I would look in your web server error logs to see what sort of errors are causing them to not display. That should give you a good starting point on diagnosing the problem.

Post Information

  • Total Posts in this topic: 26 posts
  • Users browsing this forum: No registered users and 42 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.