install errors....

Every thing seems to go correctly, however when it sets up the database I get a couple errors,:

"Table db_name.bpt_user_info' doesn't exist, "

this error is repeted sevral times however it looks like the script completes, at the bottom I get:

"

Completed OK

Administrator user created

A copy of the SQL used to create the database has been saved in files/setup.sql

"

The site is up however I cannot log in as the administrator.

 

Any Ideas,

 

Thanks,

D

File Attachments

Download Info Size (bytes) Downloaded Created
install-errors More Info 17,003 7 January 19, 2008 12:53
more info
by dhuff / at 12:56 on January 19, 2008

The table did get created....

mysql> show tables;
+-------------------------------+
| Tables_in_raleigh_raleighwood |
+-------------------------------+
| bpt_audit_log |
| bpt_comments |
| bpt_favorites |
| bpt_files |
| bpt_folder_access_list |
| bpt_folders |
| bpt_group_users |
| bpt_groups |
| bpt_invitations |
| bpt_links |
| bpt_memoranda |
| bpt_page_link_link |
| bpt_page_tag_link |
| bpt_pages |
| bpt_properties |
| bpt_quotes |
| bpt_ratings |
| bpt_rss |
| bpt_search_text |
| bpt_subscriptions |
| bpt_tag_user_link |
| bpt_tag_views |
| bpt_tags |
| bpt_templates |
| bpt_text |
| bpt_trackbacks |
| bpt_user_info |
| bpt_user_log_raw |
+-------------------------------+
28 rows in set (0.00 sec)

Thanks...
by glen / at 21:36 on January 19, 2008

that's one I haven't seen before. Do you know what version of MySQL you're using? Also, is the error "Table db_name.bpt_user_info doesn't exist" exactly? Or does it have your database name "raleigh_raleighwood" where the "db_name" is? I.e., I'm wondering if the code somewhere is actually trying to access "db_name"....

Re: Thanks...
by dhuff / at 09:09 on January 21, 2008

mysql Ver 14.7 Distrib 4.1.22, for unknown-linux-gnu (x86_64) using readline 4.3

The actual error is "Table 'raleigh_raleighwood.bpt_user_info' doesn't exist" I remove the name for the note see attachment for actual error. The code is NOT trying to access "db_name"

I also tried again with a shorter dbname, "raleigh_rw" with the same results.

I also noticed if I try to register a new user the email that is sent to confirm registration is empty.

Re: Re: Thanks...
by dhuff / at 09:14 on January 21, 2008

If I take off require email conformation I can register a new user, however it still will not let me log in.

Re: Re: Re: Thanks...
by dhuff / at 14:52 on January 22, 2008

This is really weird. I can register and create new users, which seems to work, I can even verify that the user was created in the DB with user_status=1 (which I assume means active). However when I try to login it fails. To elaborate, when I click sigh-on it appears to work however no user options and if I try to create content it takes me back to the log in screen. When I re-enter my password I get the following error:

"You must be signed on to access the requested page. Sign on using this form, and you will be redirected to the originally-requested page once you have been authenticated."

which is different form the error I get if I type a wrong password.

"Error: user name/passphrase combination not found. Please check your information and try again."

Everything else seems to be working, except for emails being sent as attachments called "noname"

Is there anyway to turn up verbosity of logging or where should I be looking for errors?

-D

Re: Re: Thanks...
by dhuff / at 07:18 on January 29, 2008

Any ideas on how to further debug this issue?

Thanks,
D