Author Topic: Sign up now page not working  (Read 1499 times)

0 Members and 1 Guest are viewing this topic.

Offline sammy02

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Sign up now page not working
« on: August 24, 2013, 01:03:17 PM »
HI,

I just recently purchase i site using jmbsoft's tubeX software.
I had the advice of the seller:
"The
registration error may be due to needing to update the software with the
open source version. The recommended process for moving tubeX sites is to
install a clean version of the software, then import the database, so
perhaps this will help."

Or do i need to look into the template code?

Help!

Offline Chad

  • Administrator
  • Full Member
  • ***
  • Posts: 215
  • Karma: +27/-0
    • View Profile
Re: Sign up now page not working
« Reply #1 on: August 24, 2013, 06:22:51 PM »
Link?

Offline remati

  • Newbie
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Sign up now page not working
« Reply #2 on: August 27, 2013, 09:56:00 PM »
I have been getting the same error along with another tubex user. I traced it down to this error in the error_log file:

Code: [Select]
[08-27-2013 05:56:25pm] Database query execution failed
Column count doesn't match value count at row 1
INSERT INTO `tbx_user_custom` VALUES ('juluis984','')
Stack Trace:
#0 /home/fmedia/public_html/domain/includes/global.php(457): Database_MySQL->Update('INSERT INTO # V...', Array)
#1 /home/fmedia/public_html/domain/user.php(476): DatabaseAdd('tbx_user_custom', Array)
#2 [internal function]: tbxRegister()
#3 /home/fmedia/public_html/domain/user.php(57): call_user_func('tbxRegister')
#4 {main}

And here is line 457 from global.php:

Code: [Select]
$DB->Update('INSERT INTO # VALUES (' . join(',', array_fill(0, $placeholders, '?')) . ')', $binds);

It is coming from this function:

Code: [Select]
function DatabaseAdd($table, $data)
{
    $DB = GetDB();
    $schema = GetDBSchema();
    $xtable = $schema->el('//table[name="'.$table.'"]');
    $primary_key = $xtable->columns->primaryKey->val();
    $xpkey_column = $xtable->el('./columns/column[name="'.$primary_key.'"]');

    $binds = array($table);
    $placeholders = 0;
    foreach( $xtable->xpath('./columns/column') as $xcolumn )
    {
        $field = $xcolumn->name->val();
        $binds[] = isset($data[$field]) ? $data[$field] : $xcolumn->default->val();
        $placeholders++;
    }

    $DB->Update('INSERT INTO # VALUES (' . join(',', array_fill(0, $placeholders, '?')) . ')', $binds);

    if( strpos($xpkey_column->definition, 'AUTO_INCREMENT') === false )
    {
        return $data[$primary_key];
    }
    else
    {
        return $DB->LastInsertId();
    }
}

So the Column count doesn't match value count at row 1

I checked my user table structure and I do not have any extra fields. Any ideas?

Offline darkorns

  • Newbie
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Sign up now page not working
« Reply #3 on: September 06, 2013, 05:49:37 AM »

Offline rogue

  • Newbie
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Re: Sign up now page not working
« Reply #4 on: January 17, 2014, 12:56:18 PM »
I have the same problem after updating PHP (god, I wish I hadn't!) anyone managed a workaround?

Offline rogue

  • Newbie
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Re: Sign up now page not working
« Reply #5 on: January 30, 2014, 06:50:00 AM »
I have the same problem after updating PHP (god, I wish I hadn't!) anyone managed a workaround?

As I'm not a programmer, the only solution I found was to downgrade PHP again.

Offline darkorns

  • Newbie
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Sign up now page not working
« Reply #6 on: January 30, 2014, 09:21:55 AM »
Looks like this is a serious problem and we don't know what else will break in future.
Is anyone interested in hiring a programmer together to fix this? We can find one on freelancer and split the costs.
I just need to know whether to move to another platform or stick with tubex, because some functions are unique to tubex.

Offline Zug

  • Newbie
  • *
  • Posts: 35
  • Karma: +12/-0
    • View Profile
    • http://www.teensinporn.biz
Re: Sign up now page not working
« Reply #7 on: January 31, 2014, 04:12:34 AM »
Looks like this is a serious problem and we don't know what else will break in future.
Is anyone interested in hiring a programmer together to fix this? We can find one on freelancer and split the costs.
I just need to know whether to move to another platform or stick with tubex, because some functions are unique to tubex.

I would be willing to pitch in what I can afford.. But who knows what the cost might be? I am not having the problem with the php. But that is not to say it might not happen in the future.
If we did this I would like the script to be updated/re-written to accept and to invoke the HTML5 player for SURE. And to also integrate into the script a splash video image used from the thumbnail generator. I am sure a few other tweaks could be great too.. like perhaps a way to post images instead of a video in a post.

Unofficial JMB Support Forums

Re: Sign up now page not working
« Reply #7 on: January 31, 2014, 04:12:34 AM »


Tags:
 

Related Topics

  Subject / Started by Replies Last post
0 Replies
980 Views
Last post July 18, 2013, 11:03:07 AM
by mrsshow
1 Replies
1308 Views
Last post August 12, 2013, 12:05:36 PM
by mrsshow
6 Replies
1953 Views
Last post January 31, 2014, 04:07:21 AM
by Zug
4 Replies
885 Views
Last post July 20, 2019, 09:39:56 PM
by insex
0 Replies
569 Views
Last post October 14, 2018, 06:44:14 AM
by kamtcho

anything