Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?
  1. Home
  2. Discussion Forum
  3. PHPFusion 8 Support
  4. Installation Issues - 8
  5. Step 4: Config / Database Setup Error [Solved]

Step 4: Config / Database Setup Error [Solved]

Asked Modified Viewed 3,883 times
Back to Forum Index Previous Topic Next Topic
Print
B
Bill1095
B
  • Newbie, joined since
  • Contributed 7 posts on the community forums.
  • Started 2 threads in the forums
  • Started this discussions
asked
Newbie

Greetings,

I have begun to set up PHPFusion on my local machine running WAMP server version 2.1 which includes Apache 2.2.17, Php version 5.3.5 and MySQL version 5.5.8. I am using PHPFusion version 7-00-07.

I am getting a "Unable to create database tables" Error. Everything before that step seems to be working fine. Before the error I have two messages that state "Database connection established & Config file successfully written."

When it tries to create the database tables I get a whole bunch of errors:

"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 'TYPE=MyISAM' at line 9You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 17You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 8You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 7You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 7You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 7..."

This repeats a good number of times. Any help would be greatly appreciated.

Thank you
Edited by Bill1095 on 22-05-2011 17:22,
0 replies

5 posts

B
Bill1095
B
  • Newbie, joined since
  • Contributed 7 posts on the community forums.
  • Started 2 threads in the forums
  • Started this discussions
answered
Newbie

An update to this issue.

I found out that TYPE= has been depreciated. The new syntax for this application should read ENGINE=MyISAM DEFAULT CHARSET=utf8. I have changed all of the entries in my setup.php file and it has created the tables.

MODS please close this thread.

Thank you.
0 replies
G
gh0st2k
G
Ex Senior Dev.
  • Member, joined since
  • Contributed 131 posts on the community forums.
answered
Member

Why do you use this "old" version!?
0 replies
B
Bill1095
B
  • Newbie, joined since
  • Contributed 7 posts on the community forums.
  • Started 2 threads in the forums
  • Started this discussions
answered
Newbie

Good question. I linked to this site from http://gscripts.net/. That was the version that downloaded for me.

Thanks.
0 replies
N
NetriX
N
NetriX 10
Need help? Having trouble?
» View our Documentation for guides, functions and more - including the Getting Started section!
» Attach Log Files and Screenshots when reporting issues
» My support days are usually Mon-Thurs. Send me a PM if urgent.
  • Senior Member, joined since
  • Contributed 566 posts on the community forums.
  • Started 93 threads in the forums
answered
Senior Member

Wow, that release was from 5 years ago.

I should download and reminisce.

Oh the irony of the memories flooding in. B)
0 replies
B
Bill1095
B
  • Newbie, joined since
  • Contributed 7 posts on the community forums.
  • Started 2 threads in the forums
  • Started this discussions
answered
Newbie

Its OK. I installed the older version on my local machine to test out the install process. I downloaded and installed version 7-02-01 to my hosted site, without any changes to the code.

I am having some trouble setting up registration. It seems I have some tweaking to do on the email registration part yet. I have searched this site for any clues on how to use Gmail as the email sever, but I haven't gotten it to work yet.

Thanks
0 replies

Category Forum

Installation Issues - 8

Labels

None yet

Statistics

  • Views 0 views
  • Posts 5 posts
  • Votes 0 votes
  • Topic users 3 members

3 participants

N
N
NetriX 10
Need help? Having trouble?
» View our Documentation for guides, functions and more - including the Getting Started section!
» Attach Log Files and Screenshots when reporting issues
» My support days are usually Mon-Thurs. Send me a PM if urgent.
  • Senior Member, joined since
  • Contributed 566 posts on the community forums.
  • Started 93 threads in the forums
G
G
Ex Senior Dev.
  • Member, joined since
  • Contributed 131 posts on the community forums.
B
B
  • Newbie, joined since
  • Contributed 7 posts on the community forums.
  • Started 2 threads in the forums
  • Started this discussions

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet