vb.org Archive - Extra Threadfields Lite(Add Text, Radio, Drop Down, & Checkbox Fields To Threads!)

Page 16 of 65

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Extra Threadfields Lite(Add Text, Radio, Drop Down, & Checkbox Fields To Threads!) (https://vborg.vbsupport.ru/showthread.php?t=108888)

Gio~Logist

03-11-2006 04:00 PM

Quote:

Originally Posted by bashy

Ok m8 cheers :)

Redownload it and try it now. Make sure you select "overwrite" when uploading xml.

bashy

03-11-2006 04:08 PM

No go for launch im afraid :( got this error

Code:

Database error in vBulletin 3.5.3:



Invalid SQL:



CREATE TABLE `thread_fields_admin` (

  `title` varchar(100) NOT NULL default '',

  `fieldid` int(10) unsigned NOT NULL auto_increment,

  `description` varchar(200) NOT NULL default '',

  `forums` varchar(200) NOT NULL default '',

  `type` varchar(100) NOT NULL default '',

  `size` char(3) NOT NULL default '40',

  `options` varchar(200) NOT NULL default '',

  `display` varchar(100) NOT NULL default '1',

  PRIMARY KEY  (`fieldid`)

) TYPE=MyISAM;;



MySQL Error  : Table 'thread_fields_admin' already exists

Error Number : 1050

Date         : Saturday, March 11th 2006 @ 06:07:43 PM

Script       : http://www.bashys-place.com/forums/admincp/plugin.php

Referrer     : http://www.bashys-place.com/forums/admincp/plugin.php?do=productadd

dakuda

03-11-2006 04:09 PM

Any clue on my error?

Gio~Logist

03-11-2006 04:16 PM

Quote:

Originally Posted by bashy

No go for launch im afraid :( got this error

Code:

Database error in vBulletin 3.5.3:



Invalid SQL:



CREATE TABLE `thread_fields_admin` (

  `title` varchar(100) NOT NULL default '',

  `fieldid` int(10) unsigned NOT NULL auto_increment,

  `description` varchar(200) NOT NULL default '',

  `forums` varchar(200) NOT NULL default '',

  `type` varchar(100) NOT NULL default '',

  `size` char(3) NOT NULL default '40',

  `options` varchar(200) NOT NULL default '',

  `display` varchar(100) NOT NULL default '1',

  PRIMARY KEY  (`fieldid`)

) TYPE=MyISAM;;



MySQL Error  : Table 'thread_fields_admin' already exists

Error Number : 1050

Date         : Saturday, March 11th 2006 @ 06:07:43 PM

Script       : http://www.bashys-place.com/forums/admincp/plugin.php

Referrer     : http://www.bashys-place.com/forums/admincp/plugin.php?do=productadd

Hm. That's not a major problem, it's just the fact that it's trying to do a query from a previos version, which it shouldn't be trying to do since you already have that. For now, just upload all files and then manually run the query:

Code:

ALTER TABLE threadfield_admin ADD COLUMN 

  `required` varchar(10) NOT NULL default 'no';

Gio~Logist

03-11-2006 04:17 PM

Quote:

Originally Posted by dakuda

Any clue on my error?

What version of mysql are your running?

klaush

03-11-2006 05:35 PM

Quote:

Originally Posted by gio~logist

Code:

ALTER TABLE threadfield_admin ADD COLUMN 

  `required` varchar(10) NOT NULL default 'no';

The problem is, you renamed the field in the sql database to threadfield_admin. So the installation prozess is unable to do the update and so it fails!

So what is the correct filed name that should be updated?

Gio~Logist

03-11-2006 05:53 PM

Quote:

Originally Posted by klaush

Wow. Why would i do that? MAJOR typo. I will fix this now.

bashy

03-11-2006 05:53 PM

Hi

I have run the query manually....

I do not have any
Extra Fields Options
I have the add field and extra fields manager but no options part
of it, any ideas....I am going to reupload the files again, this was
ok before the update!!

EDIT: reuploading has not resolved the missing options!!

Quote:

Originally Posted by gio~logist

Code:

ALTER TABLE threadfield_admin ADD COLUMN 

  `required` varchar(10) NOT NULL default 'no';

Gio~Logist

03-11-2006 05:56 PM

Quote:

Originally Posted by bashy

That's because you uninstalled the product apparently.

Also, the typo has been fixed.
ZIP UPDATED!

bashy

03-11-2006 05:59 PM

I aint uninstalled anything m8 i can assure you of that...
All i did was upload the files and imported the porduct/overwrite enabled.

Will try ya new zip now and let you know

All times are GMT. The time now is 08:12 AM.

Page 16 of 65

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01715 seconds Memory Usage 1,750KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: