• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 380
  • Last Modified:

Forum

I have a hosting package with 1and1 Internet Ltd who support My SQL and would like to know how to create a good looking forum with logins etc...

Can anyone help in the most simplest of terms?  

ziggles.
0
ziggles
Asked:
ziggles
  • 3
  • 3
1 Solution
 
dsackerContract ERP Admin/ConsultantCommented:
There are a number of open source forums that you can download, install and tailor quite nicely.

Try phpBB (http://www.phpbb.com).
0
 
zigglesAuthor Commented:
When I use the site it goes through the process and I then encounter the following error in the final stage of installation.


General Error
SQL ERROR [ sqlite ]

SQL logic error or missing database [1]

SQL

INSERT INTO phpbb_users (username, username_clean, user_password, user_pass_convert, user_email, user_email_hash, group_id, user_type, user_permissions, user_timezone, user_dateformat, user_lang, user_style, user_allow_pm, user_actkey, user_ip, user_regdate, user_passchg, user_inactive_reason, user_inactive_time, user_lastmark, user_lastvisit, user_lastpost_time, user_lastpage, user_posts, user_dst, user_colour, user_occ, user_interests, user_avatar, user_avatar_type, user_avatar_width, user_avatar_height, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_message_rules, user_full_folder, user_emailtime, user_notify, user_notify_pm, user_notify_type, user_allow_viewonline, user_allow_viewemail, user_allow_massemail, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfield) VALUES ('Nutch [Bot]', 'nutch [bot]', 'Hýýýýý', 0, 'Hýýýý]ý', '00', 6, 2, 'Hýýýýx', 0, 'D M d, Y g:i a', 'en', 1, 1, 'Hýýýýýý', 'Hýýýýýý', 1185577701, 1185577701, 0, 0, 1185577701, 0, 0, 'HýýýHý', 0, 0, '9E8DA7', 'Hýýýýý', 'Hýýý( ý', 'Hýýýýyý', 0, 0, 0, 0, 0, 0, 0, -3, 0, 0, 1, 0, 1, 1, 0, 'HýýýH¬ý', 'Hýýý`jý', 'Hýýý'ý')

BACKTRACE

FILE: includes/db/sqlite.php
LINE: 110
CALL: dbal_sqlite->sql_error()

FILE: includes/functions_user.php
LINE: 231
CALL: dbal_sqlite->sql_query()

FILE: install/install_install.php
LINE: 1851
CALL: user_add()

FILE: install/install_install.php
LINE: 106
CALL: install_install->add_bots()

FILE: install/index.php
LINE: 359
CALL: install_install->main()

FILE: install/index.php
LINE: 231
CALL: module->load()
0
 
dsackerContract ERP Admin/ConsultantCommented:
Probably somewhere in the install documentation it specified that the database needs to have been created.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
zigglesAuthor Commented:
A database has been created successfully.
0
 
dsackerContract ERP Admin/ConsultantCommented:
Was away for a bit. Were you able to find why you got the error?

Make sure you have given the database userid full rights to the database.
0
 
zigglesAuthor Commented:
No never managed to find out why I got the error message.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now