Forum installation problems...

[John Klyne]

I was in the process of writing another message in my last post but it was closed before I could hit the post button...

I keep receiving the same errors, or errors to the same extent...

When I tried to install phpbb3 ...it says

"The page is temporarily unavailable. Please try again later..."

I did. And it did work.

I clicked on install on the tab of phpbb3 so that I may install it...but then...it works after about 1 minute it loads...

I click on proceed to next step. And then click on the "start install" button on the bottom.

I input the correct information regarding database username and pass, and database name... I choose MySql as the database type, since Mysql with Mysqli Extentions did not go past this step.

I did not put a server port.

I proceeded to next step. Test connection was successful so I clicked, proceed to next step again.

I input the admin details. And proceeded to next step, which was once again successful. I clicked on proceed to next step, and then I am in the configuration step of installing phpbb3. I clicked on proceed to next step....I am not using smtp username or pass, nor is it enabled... everything looks fine. I click on proceed to next step.

It sends me to the create database tables page, and I click on proceed to next step. (Note I made the necessary file permissions as phpbb3 installation instructions said.

------
AND WAM.... This is the error I get....(note I reinstalled, and re-uploaded everything from scratch, and still I receive an error...

Here it is.

[B]General Error[/B]

			SQL ERROR [ mysqli ]

Duplicate entry 'adsbot [google]' for key 2 [1062]

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_actkey, user_ip, user_regdate, user_passchg, user_options, user_new, 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_pm, user_allow_viewonline, user_allow_viewemail, user_allow_massemail, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfield, user_form_salt) VALUES ('AdsBot [Google]', 'adsbot [google]', '', 0, '', '00', 6, 2, '', 0, 'D M d, Y g:i a', 'en', 1, '', '', 1279757295, 1279757295, 230271, 0, 0, 0, 1279757295, 0, 0, '', 0, 0, '9E8DA7', '', '', '', 0, 0, 0, 0, 0, 0, 0, -3, 0, 0, 1, 0, 1, 1, 1, 0, '', '', '', 'dfeff2d5bb350295')

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_user.php
LINE: 250
CALL: dbal_mysqli->sql_query()

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

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

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

FILE: install/index.php
LINE: 286
CALL: module->load()

...If anyone knows what I can do, or how to fix it, please, help.

Thank you, a lot in advance to trying to help me. I have been at this all day.

 

[Derek]

Those tables already exist in the database, use another one or drop all the existing ones.

 

[Livewire]

Go into the table phpbb_users and remove all the bots already dumped in there - what's happening is it must've crashed on you before partway through adding them, and now it's freaking out cause it's trying to re-add the googleBot with Primary Key #2, which is both in use and the same exact bot.


Long story short, table's not empty, and phpbb didn't think to check if there -was- before it started trying to insert new data.