Author Topic: Signup Error  (Read 3078 times)

0 Members and 1 Guest are viewing this topic.

Offline jumpinjack

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Signup Error
« on: August 01, 2013, 03:54:25 PM »
I get the following error when I try to register a new user via the Tubex signup page:

Code: [Select]
An Error Has Occurred Database query execution failed The site administrator has been notified of this issue and will look into it as soon as possible

When I look at the data/error_log, I see the following:

Code: [Select]
[08-01-2013 04:36:25pm] Database query execution failed
Column 'username' cannot be null
INSERT INTO `tbx_user` VALUES (NULL,'','','2013-08-01 16:36:25','Submitted',NULL,NULL,'',NULL,'Male','Single','','','','','','','','','','','','','')
        Stack Trace:
                #0 /srv/public_html/tube/includes/global.php(469): Database_MySQL->Update('INSERT INTO # V...', Array)
                #1 /srv/public_html/tube/user.php(481): DatabaseAdd('tbx_user', Array)
                #2 [internal function]: tbxRegister()
                #3 /srv/public_html/tube/user.php(63): call_user_func('tbxRegister')
                #4 {main}


BTW: I am able to add a user via the admin page.

All server test elements are green and I'm running PHP 5.4.16 & Mysql 5.6.12

Any help would be great.

Thanks
« Last Edit: August 01, 2013, 03:57:29 PM by jumpinjack »

Offline darkorns

  • Newbie
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Signup Error
« Reply #1 on: September 06, 2013, 05:22:58 AM »
Having the same problem on the server with the following:
5.1.70-cll - MySQl
5.4.19 - PHP
Linux 2.6.32-042stab062.2

But don't have this issue on the server with the following:
5.1.69 - MySQl
5.3.3 - PHP
Linux 2.6.32-042stab079.5

Can somebody address this?

Thank you!

« Last Edit: September 06, 2013, 05:28:00 AM by darkorns »

Offline darkorns

  • Newbie
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Signup Error
« Reply #2 on: September 06, 2013, 05:42:30 AM »
Here is an update:
I recompiled apache with php 5.3.27 and it works now. So, definately the php is a problem.
I would like someone to check if there is a workaround for this because eventually, we will have to update the php.

Thank you!

Offline Huge

  • Newbie
  • *
  • Posts: 13
  • Karma: +7/-0
    • View Profile
Re: Signup Error
« Reply #3 on: November 21, 2013, 05:11:43 AM »
I'm having this same problem with my tubex. My server setup is php 5.5.5, mysql 5.5.32 and it produces the same error when someone tries to register as a new user.  Has anyone figured out a work around to fix this?  Is the only way to fix this to downgrade to an older version of php?

Offline rogue

  • Newbie
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Re: Signup Error
« Reply #4 on: January 17, 2014, 01:00:59 PM »
a bump for this important issue

Offline Zug

  • Newbie
  • *
  • Posts: 35
  • Karma: +12/-0
    • View Profile
    • http://www.teensinporn.biz
Re: Signup Error
« Reply #5 on: January 29, 2014, 08:24:56 AM »
Hello. I am not sure if this helps. This is probably something you already know.

I do believe that Tubex is not designed to run with PHP4.?.+ 80% sure
The software will just not function correctly for some reason. I have heard this. I tried looking up some info about it but could not find anything useful to support it.

I have had this problem before when I moved to a different host. They had to set it up to run Tubex with an older version of PHP. Which is fine with me. I also have WP installed on the same domain. So, not sure what php version is required for that. But they both work on the same domain where Tubex is installed. I would suggest that you talk to your host about the issue and see if they can come up with a work around.

For some of these other errors. You may be able to try running the Database utilities from inside the tubex admin. Run the repair database function and then the optimize function.
Then flush and recompile your pages. Clear your history and cookies and try again.

Hope something in there helped.


Offline hunkyluke

  • New Users
  • Newbie
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Signup Error
« Reply #6 on: April 08, 2015, 05:43:00 PM »
has anyone come up with a solution to this, keeping php 5.4 and getting the user registration working again?

thanks!!

Unofficial JMB Support Forums

Re: Signup Error
« Reply #6 on: April 08, 2015, 05:43:00 PM »


Tags:
 

Related Topics

  Subject / Started by Replies Last post
5 Replies
1408 Views
Last post September 17, 2013, 06:42:45 PM
by Chad
0 Replies
1062 Views
Last post August 05, 2013, 07:04:44 PM
by Chad
0 Replies
1264 Views
Last post August 05, 2013, 07:07:54 PM
by Chad
3 Replies
2094 Views
Last post March 14, 2016, 07:52:59 PM
by longsack
0 Replies
1022 Views
Last post October 16, 2014, 05:28:09 PM
by swingermoney

anything