7.1.3 Database error on Join

LifeStyleHookup.com 

 

 

You get everything filled out and hit join and it just takes you to a blank page that says its a database error but you back out and login and everything is there and fine!

 

Quote · 17 Jul 2013

Look in the logs and find the entry and post the error code here.

It is probably writing part of the data to the Profiles table until it hits the error; if I understood you correctly.

Geeks, making the world a better place
Quote · 17 Jul 2013

you need to enable DB debugging, check the steps from here

http://www.boonex.com/forums/topic/-Database-query-error.htm#165963

so much to do....
Quote · 17 Jul 2013
INSERT INTO USERS_TABLE (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_options, 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, user_form_salt) VALUES ('testing', 'testing', '0cd772325c98ee0eed5f85e8c8a70fc9d00afc6c', 0, '2@yahoo.com', '115717153811', 2, 0, '', '-7', 'D M d, Y g:i a', 'en', '5', 1, '', '', 1374093590, 1374093590, 895, 0, 0, 1374093590, 0, 0, '', 0, 0, '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 'PRIVMSGS_NO_BOX', 0, 0, 1, 'NOTIFY_EMAIL', 1, 1, 1, '', '', '', 'e46018da69b7de08')
Mysql error:
Table 'zedrwx_main.USERS_TABLE' doesn't exist
 
This must be missing in the 7.1.3 update script
Quote · 17 Jul 2013

This table is not in the 7.1 release eather

Quote · 17 Jul 2013

Not a dolphin table.

Do you by any chance have some kind of phpbb mod in place?

https://www.deanbassett.com
Quote · 17 Jul 2013

No, the table for member's data is Profiles (with a capital P).  Oops, something is not right here.

Geeks, making the world a better place
Quote · 17 Jul 2013

I started to install one but it gave a big error LOL so now i know why that does not work eather. I uninstalled it but that must not have fixed this

Quote · 17 Jul 2013

Was there an edit to the join script?  My guess is that it adds to the profiles table which is why the user is created and you can log in; however, then it tries to add to the USERS_TABLE and fails because the table is not there. 

Geeks, making the world a better place
Quote · 17 Jul 2013

No i believe its in the database i am looking now.

Quote · 17 Jul 2013

Where can i define the database field names?

Quote · 17 Jul 2013

 

No i believe its in the database i am looking now.

No, this would not be in the database.  It is the scripts that connect to the database and updates the table.  

You said that the profile is created and that you can go back and then log in.  That part is working.

Look at the installation instructions that came with the module.  It told you what files to edit to get it to write to the now missing USERS_TABLE.

Geeks, making the world a better place
Quote · 17 Jul 2013

Or, do a search through the files for "USERS_TABLE" using notepad++, or pspad, or your favourite text editor that can search through files for key word(s).

Geeks, making the world a better place
Quote · 17 Jul 2013

USERS_TABLE is most likely defined as a variable and your file permissions do not allow you to include the script that sets the  variable.

Since this is a fresh install, truncate your database and if there is a header.inc.php file in the inc diretory of the Dolphin root, delete that file, before starting a new install.

 

This time please let us know your first error message, before going to the next step of the installation

Dedicated servers for as little as $32 (28 euro) - See http://denre.com for more information
Quote · 17 Jul 2013

Mysql error:
Table 'zedrwx_main.USERS_TABLE' doesn't exist

The script that processes the join form is trying to insert values into a table that does not exist.  Remove that part and be happy.

Geeks, making the world a better place
Quote · 17 Jul 2013

Fixed it by just a define('USER_TABLE', "phpbb_users");

Quote · 17 Jul 2013
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.