Gossamer Forum
Home : Products : Gossamer Links : Discussions :

$100 Paypal if you can solve this...

Quote Reply
$100 Paypal if you can solve this...
I lost my database and am attempting to recover using the backups. I'm frustrated as hell and have been trying to do this for 3 days now. It's quite simple I'm sure, but it's killing me.

Of course it's the familiar problem:

WARNING: Unable to import `36885 Link Title Here http://www.link.com/ admin 2003-09-10 2003-09-10 Link Description Here. Vlad webmaster@mysite.com No No No Yes 0 0000-00-00 00:00:00 20040531110427 0 Free 12.57 NotSent 0' (line 1359 of /home/h2/cgi-bin/xql/admin/backup/BACKUP): called with 22 bind variables when 20 are needed


My DEF file shows that I only use 20 fields, but the link information above shows that I am using 22 fields. Notice the last two entries. "NotSent|0" They aren't in the def file. I've also included the "|" delimited version of this below so you can count the fields. The DEF file is at the bottom of this message.


36885|Link Title Here|http://www.link.com/|admin|2003-11-04|2003-11-04|This is just the description.|Serjant|webmaster@mysite.com|No|No|No|Yes|0|0000-00-00 00:00:00|20040502080416||0|Free|15.36|NotSent|0


So, I've updated the LINKS table with the necessary information as spelled out above, resynced the database, repaired the tables and I alway get the same thing: "called with 22 bind variables when 20 are needed". Even if I add 10 extra fields to the LINKs table, it will still say the same thing.

Help me please! I'll send you $100 paypal.

Marc
icq: 24142711







MY DEF FILE:

{
'ai' => 'ID',
'cols' => {
'ID' => {
'default' => '0',
'form_display' => 'ID',
'form_size' => '10',
'form_type' => 'TEXT',
'not_null' => '1',
'pos' => '1',
'regex' => '^\d+$',
'type' => 'INT',
'unsigned' => '1',
'zerofill' => '0'


},
'Title' => {
'binary' => '0',
'file_max_size' => '',
'file_save_in' => '',
'file_save_scheme' => 'HASHED',
'file_save_url' => '',
'form_display' => 'Title',
'form_size' => '40',
'form_type' => 'TEXT',
'not_null' => '1',
'pos' => '2',
'regex' => '',
'size' => '100',
'type' => 'VARCHAR',
'weight' => '3'
},
'URL' => {
'binary' => '0',
'default' => 'http://',
'file_max_size' => '',
'file_save_in' => '',
'file_save_scheme' => 'HASHED',
'file_save_url' => '',
'form_display' => 'URL',
'form_size' => '40',
'form_type' => 'TEXT',
'not_null' => '1',
'pos' => '3',
'regex' => '^\w+:',
'size' => '255',
'type' => 'VARCHAR',
'weight' => '1'
},
'LinkOwner' => {
'binary' => '0',
'default' => 'admin',
'form_display' => 'LinkOwner',
'form_size' => '20',
'form_type' => 'TEXT',
'not_null' => '1',
'pos' => '4',
'size' => '50',
'type' => 'VARCHAR'
},
'Add_Date' => {
'default' => '0000-00-00',
'file_max_size' => '',
'file_save_in' => '',
'file_save_scheme' => 'HASHED',
'file_save_url' => '',
'form_display' => 'Add Date',
'form_size' => '20',
'form_type' => 'TEXT',
'not_null' => '1',
'pos' => '5',
'regex' => '',
'type' => 'DATE',
'weight' => ''
},
'Mod_Date' => {
'default' => '0000-00-00',
'form_display' => 'Mod Date',
'form_size' => '20',
'form_type' => 'DATE',
'not_null' => '1',
'pos' => '6',
'type' => 'DATE'
},
'Description' => {
'default' => '',
'form_display' => 'Description',
'form_size' => '30',
'form_type' => 'TEXTAREA',
'not_null' => '0',
'pos' => '7',
'type' => 'TEXT',
'weight' => '1'
},
'Contact_Name' => {
'binary' => '0',
'default' => '',
'form_display' => 'Contact Name',
'form_size' => '20',
'form_type' => 'TEXT',
'not_null' => '0',
'pos' => '8',
'size' => '255',
'type' => 'VARCHAR'
},
'Contact_Email' => {
'binary' => '0',
'default' => '',
'form_display' => 'Contact Email',
'form_size' => '20',
'form_type' => 'TEXT',
'not_null' => '0',
'pos' => '9',
'size' => '255',
'type' => 'VARCHAR'
},
'isNew' => {
'default' => 'No',
'form_display' => 'isNew',
'form_type' => 'SELECT',
'not_null' => '1',
'pos' => '11',
'type' => 'ENUM',
'values' => [
'No',
'Yes'
]
},
'isChanged' => {
'default' => 'No',
'form_display' => 'isChanged',
'form_type' => 'SELECT',
'not_null' => '1',
'pos' => '12',
'type' => 'ENUM',
'values' => [
'No',
'Yes'
]
},
'isPopular' => {
'default' => 'No',
'form_display' => 'isPopular',
'form_type' => 'SELECT',
'not_null' => '1',
'pos' => '13',
'type' => 'ENUM',
'values' => [
'No',
'Yes'
]
},
'isValidated' => {
'default' => 'Yes',
'form_display' => 'isValidated',
'form_type' => 'SELECT',
'not_null' => '1',
'pos' => '14',
'type' => 'ENUM',
'values' => [
'No',
'Yes'
]
},
'Status' => {
'default' => '0',
'form_display' => 'Status',
'form_size' => '10',
'form_type' => 'TEXT',
'not_null' => '1',
'pos' => '17',
'regex' => '^\-?\d+$',
'type' => 'SMALLINT',
'unsigned' => '0',
'zerofill' => '0'
},
'Date_Checked' => {
'default' => '0000-00-00 00:00:00',
'form_display' => 'Date Checked',
'form_size' => '20',
'form_type' => 'DATE',
'not_null' => '0',
'pos' => '18',
'type' => 'DATETIME'
},
'Timestmp' => {
'default' => '',
'form_display' => 'Timestamp',
'form_size' => '20',
'form_type' => 'DATE',
'not_null' => '0',
'pos' => '19',
'time_check' => '1',
'type' => 'TIMESTAMP'
},
'Notes' => {
'default' => '',
'form_size' => [
'50',
'8'
],
'form_type' => 'TEXTAREA',
'not_null' => '0',
'pos' => '20',
'size' => '500',
'type' => 'TEXT'

},
'Mouseover' => {
'binary' => '0',
'default' => '',
'form_size' => '40',
'form_type' => 'TEXT',
'not_null' => '1',
'pos' => '21',
'size' => '150',
'type' => 'VARCHAR'

},
'Type' => {
'binary' => '0',
'default' => '',
'form_size' => '20',
'form_type' => 'TEXT',
'not_null' => '1',
'pos' => '24',
'regex' => 'Free|Pay|AVS|Trade',
'size' => '5',
'type' => 'VARCHAR'
},
'Randomizer' => {
'decimal' => '2',
'default' => '',
'display' => '10',
'not_null' => '0',
'pos' => '26',
'precision' => '10',
'type' => 'FLOAT',
'zerofill' => '0'
}
},
'fk' => {
'lsql_Users' => {
'LinkOwner' => 'Username'
}
},
'fk_tables' => [
'lsql_Changes',
'lsql_Reviews',
'lsql_CatLinks',
'lsql_Verify'
],
'index' => {
'newndx' => [
'isNew'
],
'popndx' => [
'isPopular'
],
'stndx' => [
'Status'
],
'urlndx' => [
'URL'
],
'userndx' => [
'LinkOwner'
],
'valndx' => [
'isValidated'
]
},
'pk' => [
'ID'
],
'subclass' => {
'html' => {
'lsql_Links' => 'Links::Link::HTML'
},
'table' => {
'lsql_Links' => 'Links::Link'
}
},
'unique' => {}
};
Quote Reply
Re: [mb] $100 Paypal if you can solve this... In reply to
Did you manually edit the backup, and delete the |NotSent|0 bit from the row corresponding to ID=36885 in the Links table? That should do it.

----
Cheers,

Dan
Founder and CEO

LionsGate Creative
GoodPassRobot
Magelln
Quote Reply
Re: [dan] $100 Paypal if you can solve this... In reply to
What email address can I send the money to?

thanks,
marc
Quote Reply
Re: [mb] $100 Paypal if you can solve this... In reply to
Glad to hear that the issue was resolved. There's no charge - especially at $50 per minute =) It's what we all here for, to help each other as a community for GT products.

----
Cheers,

Dan
Founder and CEO

LionsGate Creative
GoodPassRobot
Magelln
Quote Reply
Re: [dan] $100 Paypal if you can solve this... In reply to
Thanks so much, Dan!

marc
Quote Reply
Re: [mb] $100 Paypal if you can solve this... In reply to
You're welcome, Marc!

----
Cheers,

Dan
Founder and CEO

LionsGate Creative
GoodPassRobot
Magelln
Quote Reply
Re: [dan] $100 Paypal if you can solve this... In reply to
You are great marc !! I am glad to see people like you here in the forums.
>> Nakul Goyal (SEO, Link Building Expert)
Web Site Promotion
Tips 'n' Tricks
SEO News


Quote Reply
Re: [nakulgoyal] $100 Paypal if you can solve this... In reply to
I think Dan is the great one since he fixed marc's problem - though I'm sure marc is great too in his own way Wink.
Quote Reply
Re: [aus_dave] $100 Paypal if you can solve this... In reply to
Sorry Marc, I gave you extra credit Sly
I meant Dan :)
>> Nakul Goyal (SEO, Link Building Expert)
Web Site Promotion
Tips 'n' Tricks
SEO News


Quote Reply
Re: [nakulgoyal] $100 Paypal if you can solve this... In reply to
Yep, I figured you meant me =) And, thanks!

----
Cheers,

Dan
Founder and CEO

LionsGate Creative
GoodPassRobot
Magelln