Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Registration data not being saved, user_id=0

Registration data not being saved, user_id=0 14 years 1 month ago #10213

  • iangrantdavidson
  • iangrantdavidson's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 2
  • Thank you received: 0
Registration records are not available after registering for an event. I believe this is because user_id always seems to be 0. The data in the user_field_values is constantly overwritten, with the user_id set to 0. Any idea if there is some configuration or table setup that is causing this? Thanks!!!

We have 2 payment options. When paying through paypal no error is created, but no registration records, or new user (when using new email address) is created.

When using the call in payment, the following error is displayed on the page:

No valid database connection 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 '' at line 1 SQL=select * from jos_dtregister_fee where user_id=
No valid database connection 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 '' at line 1 SQL=select * from jos_dtregister_group_member where groupUserId =
No valid database connection 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 '' at line 1 SQL=select * from jos_dtregister_user_field_values where user_id =


Thanks!
To complete your registration for , please COMPLETE YOUR DEPOSIT PAYMENT.
You will not be registered until we have received your deposit. You can either call us to pay by credit card, or send us a cheque in the post (French bank cheques only please).
You will receive an email receipt of your registration. If you are logged into the website (requires registration), you can also access the forum, where people discuss lift sharing and other topics.

Please Log in or Create an account to join the conversation.

Registration data not being saved, user_id=0 14 years 3 weeks ago #10436

  • psmith
  • psmith's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 10
  • Thank you received: 0
I am also having this issue with 2.7.0i installed. It doesn't seem to matter which payment method I have selected.

Turned on Joomla debugging and have the following info for you:
No valid database connection:

Call stack
# 	Function 	Location
1 	JSession->__destruct() 	 
2 	JSession->close() 	/Users/psmith/Sites/hockey/libraries/joomla/session/session.php:135
3 	session_write_close() 	/Users/psmith/Sites/hockey/libraries/joomla/session/session.php:562
4 	JSessionStorageDatabase->write() 	 
5 	JTable->store() 	/Users/psmith/Sites/hockey/libraries/joomla/session/storage/database.php:92
6 	JFDatabase->updateObject() 	/Users/psmith/Sites/hockey/libraries/joomla/database/table.php:285
7 	JDatabaseMySQL->updateObject() 	/Users/psmith/Sites/hockey/plugins/system/jfdatabase/jfdatabase_inherit.php:602
8 	JFDatabase->query() 	/Users/psmith/Sites/hockey/libraries/joomla/database/database/mysql.php:583
9 	interceptDB->setRefTables() 	/Users/psmith/Sites/hockey/plugins/system/jfdatabase/jfdatabase_inherit.php:642
10 	interceptDB->_getFieldCount() 	/Users/psmith/Sites/hockey/plugins/system/jfdatabase/intercept.jdatabasemysql.php:225
11 	JError->raiseError() 	/Users/psmith/Sites/hockey/plugins/system/jfdatabase/intercept.jdatabasemysql.php:79
12 	JError->raise() 	/Users/psmith/Sites/hockey/libraries/joomla/error/error.php:171
13 	JException->__construct() 	/Users/psmith/Sites/hockey/libraries/joomla/error/error.php:136

Please Log in or Create an account to join the conversation.

Registration data not being saved, user_id=0 14 years 3 weeks ago #10437

  • psmith
  • psmith's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 10
  • Thank you received: 0
Is DT Register destroying all session data on the site??

After getting the initial 500 error with Joomla debug turned on, I instantly get another 500 error when trying to go to the registration component landing screen.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.097 seconds