vb.org Archive
Page 3 of 5 12 3 45
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Add-On Releases - [BFC] Applicator (https://vborg.vbsupport.ru/showthread.php?t=213907)

nalexandre 05-18-2009 03:39 PM
Quote:
Originally Posted by EnIgMa1234 (Post 1812957)
Updated :) Thread Posting is now added.
Thank you.

EnIgMa1234 05-18-2009 03:40 PM
Quote:
Originally Posted by nalexandre (Post 1812995)
Thank you, it gives an error when i try to download.
Downloading the addon from here?
What error does it give?

tafreeh 05-18-2009 07:31 PM
great mod... but can we add a separator after X question , plus can we change line in question.... or add description of question right below it.... for example...
You asked question in English and u want add Spanish translation underneath it.

but its great mod.... i will try it definitely as soon as you add these features... if not possible i will still give it a chance:)

The D 05-18-2009 07:37 PM
I keep getting SQL errors left and right with missing tables. I reinstalled it and it still errors out. I can't click the 'Main' link nor can I create new applications.

EnIgMa1234 05-18-2009 08:47 PM
Quote:
Originally Posted by The D (Post 1813122)
I keep getting SQL errors left and right with missing tables. I reinstalled it and it still errors out. I can't click the 'Main' link nor can I create new applications.
Could you post the error please :)

The D 05-19-2009 03:15 AM
Sure thing. :) I had the error while installing like the others, but here is the SQL errors I was getting.

Code:
                SELECT *
                FROM applicator_app
                ORDER BY appid ASC;

MySQL Error  : Table 'forum_vb.applicator_app' doesn't exist

It apparently didn't create the tables for some reason.

sargatanas 05-19-2009 09:35 AM
Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT *
FROM applicator_app
ORDER BY appid ASC;

MySQL Error : Table 'sargatanas.applicator_app' doesn't exist
Error Number : 1146
Request Date : Tuesday, May 19th 2009 @ 03:34:16 AM
Error Date : Tuesday, May 19th 2009 @ 03:34:16 AM

Help Please

EnIgMa1234 05-19-2009 02:43 PM
Ok uninstall the old product and reimport the new one - Overwrite = No

MrEyes 05-19-2009 09:11 PM
There is a "bug" in the current product file:

On install you get the following error:

Code:
Database error in vBulletin 3.8.0:

Invalid SQL:
CREATE TABLE IF NOT EXISTSapplicator_app (
`appid` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`appname` VARCHAR( 100 ) NOT NULL DEFAULT 'Name',
`appactive` TINYINT( 1 ) NOT NULL DEFAULT '1',
`appperms` VARCHAR( 150 ) NOT NULL DEFAULT '0',
UNIQUE (
`appid`
)
);

MySQL Error  : 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 'EXISTSapplicator_app (
`appid` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`appname` V' at line 1
Error Number  : 1064
Request Date  : Tuesday, May 19th 2009 @ 10:37:40 PM
Error Date    : Tuesday, May 19th 2009 @ 10:37:40 PM
Script        : http://www.wibble.com/admincp/plugin.php
Referrer      : http://www.wibble.com/admincp/plugin.php?do=productadd
IP Address    : 90.213.65.43
Username      : Wibble
Classname    : vB_Database
MySQL Version : 5.0.45-community-nt
This is becuase of a missing space in the product XML, the following line:

Code:
$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS".TABLE_PREFIX."`applicator_question` (
Should be:
Code:
$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS ".TABLE_PREFIX."`applicator_question` (
Notice the space after EXISTS

Also there is a bug in the navbits, at the moment navbits is set using this code:

Code:
$navbits[$parent] = $vbphrase['bs_newbattle'];
and that phrase doesn't exists and isn't created by the product install, for now I have changed this to:

Code:
$navbits[$parent] = 'Applications'
However it would be better if this was the name of the application being viewed.

Also, I need to ask some fairly long questions but the question DB field is only 150 characters, so I have changed this to MEDIUMTEXT

And finally, if a user submits an application and then tries to resubmit another they get a standard (unphrased) "Error while posting application. Please try again." message - if the user has already submitted then it should really display their current submission and remove the submit button - or even better have a config value for each application that sets whether the user can resubmit.

Looks like a fantastic mod, but need a little polish before it is ready to go on live sites.

sargatanas 05-20-2009 04:21 AM
Quote:
Originally Posted by MrEyes (Post 1813729)
There is a "bug" in the current product file:

On install you get the following error:

Code:
Database error in vBulletin 3.8.0:

Invalid SQL:
CREATE TABLE IF NOT EXISTSapplicator_app (
`appid` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`appname` VARCHAR( 100 ) NOT NULL DEFAULT 'Name',
`appactive` TINYINT( 1 ) NOT NULL DEFAULT '1',
`appperms` VARCHAR( 150 ) NOT NULL DEFAULT '0',
UNIQUE (
`appid`
)
);

MySQL Error  : 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 'EXISTSapplicator_app (
`appid` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`appname` V' at line 1
Error Number  : 1064
Request Date  : Tuesday, May 19th 2009 @ 10:37:40 PM
Error Date    : Tuesday, May 19th 2009 @ 10:37:40 PM
Script        : http://www.wibble.com/admincp/plugin.php
Referrer      : http://www.wibble.com/admincp/plugin.php?do=productadd
IP Address    : 90.213.65.43
Username      : Wibble
Classname    : vB_Database
MySQL Version : 5.0.45-community-nt
This is becuase of a missing space in the product XML, the following line:

Code:
$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS".TABLE_PREFIX."`applicator_question` (
Should be:
Code:
$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS ".TABLE_PREFIX."`applicator_question` (
Notice the space after EXISTS

Also there is a bug in the navbits, at the moment navbits is set using this code:

Code:
$navbits[$parent] = $vbphrase['bs_newbattle'];
and that phrase doesn't exists and isn't created by the product install, for now I have changed this to:

Code:
$navbits[$parent] = 'Applications'
However it would be better if this was the name of the application being viewed.

Also, I need to ask some fairly long questions but the question DB field is only 150 characters, so I have changed this to MEDIUMTEXT

And finally, if a user submits an application and then tries to resubmit another they get a standard (unphrased) "Error while posting application. Please try again." message - if the user has already submitted then it should really display their current submission and remove the submit button - or even better have a config value for each application that sets whether the user can resubmit.

Looks like a fantastic mod, but need a little polish before it is ready to go on live sites.
very well said. :up:


All times are GMT. The time now is 02:50 PM.
Page 3 of 5 12 3 45
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01182 seconds
  • Memory Usage 1,755KB
  • 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
  • (11)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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