vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Add-On Releases - [1.3] vBWonders - Paid Features for free (18+ Paid Feature for Free!) (https://vborg.vbsupport.ru/showthread.php?t=318986)

Guardian Hope 06-12-2015 02:56 PM

This post will likely be merged with my other post

I tried your new install script and the install script doesn't even work:

HTML Code:

Warning: mysqli_query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( `page_id` INT(11) NOT NULL AUTO_INCREMENT,`page_title` VARCHAR(250) NOT NU' at line 1 in ..../includes/class_core.php on line 1393
And naturally, a vBulletin database error to go a long with it:

HTML Code:

Database error in vBulletin 4.2.2:

Invalid SQL:
CREATE TABLE dbprefixremoved_`vbwonders_pages` (
    `page_id` INT(11) NOT NULL AUTO_INCREMENT,`page_title` VARCHAR(250) NOT NULL,`page_content` VARCHAR(250) NOT NULL,`page_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,PRIMARY KEY (`page_id`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(
    `page_id` INT(11) NOT NULL AUTO_INCREMENT,`page_title` VARCHAR(250) NOT NU' at line 1
Error Number  : 1064
Request Date  : Friday, June 12th 2015 @ 09:52:52 AM
Error Date    : Friday, June 12th 2015 @ 09:52:52 AM
Script        : http://domainremoved/forums/vbwonders_install.php?ModPagespeed=off
Referrer      :
IP Address    : [IP Removed]
Username      : [Username Removed]
Classname    : vB_Database_MySQLi
MySQL Version : 5.5.40-MariaDB-cll-lve

Believe me when I say I do want this modification to work. It just doesn't seem like it's going to.

vBWonders 06-12-2015 03:00 PM

Quote:

Originally Posted by Guardian Hope (Post 2547703)
This post will likely be merged with my other post

I tried your new install script and the install script doesn't even work:

HTML Code:

Warning: mysqli_query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( `page_id` INT(11) NOT NULL AUTO_INCREMENT,`page_title` VARCHAR(250) NOT NU' at line 1 in ..../includes/class_core.php on line 1393
And naturally, a vBulletin database error to go a long with it:

HTML Code:

Database error in vBulletin 4.2.2:

Invalid SQL:
CREATE TABLE dbprefixremoved_`vbwonders_pages` (
    `page_id` INT(11) NOT NULL AUTO_INCREMENT,`page_title` VARCHAR(250) NOT NULL,`page_content` VARCHAR(250) NOT NULL,`page_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,PRIMARY KEY (`page_id`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(
    `page_id` INT(11) NOT NULL AUTO_INCREMENT,`page_title` VARCHAR(250) NOT NU' at line 1
Error Number  : 1064
Request Date  : Friday, June 12th 2015 @ 09:52:52 AM
Error Date    : Friday, June 12th 2015 @ 09:52:52 AM
Script        : http://domainremoved/forums/vbwonders_install.php?ModPagespeed=off
Referrer      :
IP Address    : [IP Removed]
Username      : [Username Removed]
Classname    : vB_Database_MySQLi
MySQL Version : 5.5.40-MariaDB-cll-lve

Believe me when I say I do want this modification to work. It just doesn't seem like it's going to.

Please send a pm to me with your forum login info for troubleshooting, I need to check the tables prefixes and compare it with the current in your database.

I'll install it for you

Guardian Hope 06-12-2015 03:12 PM

Quote:

Originally Posted by vBWonders (Post 2547704)
Please send a pm to me with your forum login info for troubleshooting, I need to check the tables prefixes and compare it with the current in your database.

I'll install it for you

I have sent you temporary login credentials which will give you access to everything you need I believe.

vBWonders 06-12-2015 03:27 PM

Replied, Thank you so much :)

You've a misconfigured table prefixes and I'm able to re-produce the same error with your default vBulletin tables like "user" table. Your forum is looking for a totally different table prefixe than what your tables are actually have!!

I'll update the thread here with what was going on, with much more info.

Please reply to the PM that I've sent it to you.

Guardian Hope 06-12-2015 03:42 PM

Quote:

Originally Posted by vBWonders (Post 2547708)
Replied, Thank you so much :)

You've a misconfigured table prefixes and I'm able to re-produce the same error with your default vBulletin tables like "user" table. Your forum is looking for a totally different table prefixe than what your tables are actually have!!

I'll update the thread here with what was going on, with much more info.

Please reply to the PM that I've sent it to you.

PM reply sent.

Interestingly, nothing has modified that database in such a manner although it was originally developed on a server not under my own control (HostGator) and was migrated to one of the many networks I own after sometime in development.

No other mod has presented with this issue and vBulletin has run quite well and stable.

Wedframe 06-13-2015 09:32 AM

Quote:

Originally Posted by vBWonders (Post 2547687)
Updated version :

1- Fixed the table prefix issue.
2- Fixed a bug in the advanced template editor.

Nop... There is still missing scroll-bars in fullscreen mode....

Wedframe 06-13-2015 10:13 AM

Quote:

Anyway you are the ONLY one who have this issue don't worry no one has it
No! I have this issue too. BUT! Exactly the same issue, only appears when I open in the browser vbwonders_install.php file, AFTER installing the product Product_vBWonders.xml in the admin panel.
Itself product is installed without error as many times as desired )))

@Guardian Hope, just remove vbwonders_install.php and install from admin panel new Product_vBWonders.xml product.

Marco, your mistake is just that you have not added for the correct update instructions...

Good luck!

Wedframe 06-13-2015 11:00 AM

And.... looks like hashtags don`t work for me. I`m use charset cp1251. May be problem in this?

Quote:

Looks like you've a modifications conflict
Yeah. Then I dissable FractalizeR: Show items, awaiting moderation in notifications area, looks like everything work fine. On what moment, I comment string #168 in Marco.Notifications.php and have both mods working.

Guardian Hope 06-13-2015 11:03 PM

Quote:

Originally Posted by Wedframe (Post 2547744)
No! I have this issue too. BUT! Exactly the same issue, only appears when I open in the browser vbwonders_install.php file, AFTER installing the product Product_vBWonders.xml in the admin panel.
Itself product is installed without error as many times as desired )))

@Guardian Hope, just remove vbwonders_install.php and install from admin panel new Product_vBWonders.xml product.

Marco, your mistake is just that you have not added for the correct update instructions...

Good luck!

Yeah, I gave up on the vBWonders Mod simply because it does not work and was likely released way to soon. My issue arises when you run the XML file - not the installer which isn't actually capable of properly interacting with MySQL.

I'll pay DBTech for hashtag support. I support coders and designers but this has to be the one coder that will stand out to me the most and not for good reasons (see the final PM I sent the author):

I was going to write a rather long and drawn out message about how problematic your modification actually is after I had an IT team with far more experience than you or this other vBulletin Coder you were going to speak to about this but than I realized that you are unwilling to accept that your modification is faulty.

Even another user reported the same thing and I had a team of 27 people test your mod out on a fresh installation of vBulletin on an EC2 instance just for the sake of testing it out.

You're the author: it's up to you to do whatever you want but the reality is your modification doesn't properly interact with MySQL.

Take with that what you will but I am done. I have revoked your FTP access and restored the database to remove any damage you may have done because vBulletin was actually reading the correct tables and was not at fault.

I typically support coders and developers but you really should adjust your attitude as well. Given our series of PMs it told me that you had absolutely no idea what you were doing the moment you entered our environment. You, I cannot support.

This is the end of the discussion.


Although that last line is from the PM it still holds true. Install this modification at your own risk but you better make sure you have a usable backup copy of the database because this modification doesn't interact with MySQL properly.

I would avoid it at all costs and go for the paid versions that this tries to circumvent. Although we all have to start somewhere I will never download such a modification (one supposed to be extremely advanced) from a first time developer.

This is the end to any responses from me.

mansonklan 06-14-2015 12:32 AM

Quote:

Originally Posted by Guardian Hope (Post 2547764)
Yeah, I gave up on the vBWonders Mod simply because it does not work and was likely released way to soon. My issue arises when you run the XML file - not the installer which isn't actually capable of properly interacting with MySQL.

I'll pay DBTech for hashtag support. I support coders and designers but this has to be the one coder that will stand out to me the most and not for good reasons (see the final PM I sent the author):

I was going to write a rather long and drawn out message about how problematic your modification actually is after I had an IT team with far more experience than you or this other vBulletin Coder you were going to speak to about this but than I realized that you are unwilling to accept that your modification is faulty.

Even another user reported the same thing and I had a team of 27 people test your mod out on a fresh installation of vBulletin on an EC2 instance just for the sake of testing it out.

You're the author: it's up to you to do whatever you want but the reality is your modification doesn't properly interact with MySQL.

Take with that what you will but I am done. I have revoked your FTP access and restored the database to remove any damage you may have done because vBulletin was actually reading the correct tables and was not at fault.

I typically support coders and developers but you really should adjust your attitude as well. Given our series of PMs it told me that you had absolutely no idea what you were doing the moment you entered our environment. You, I cannot support.

This is the end of the discussion.


Although that last line is from the PM it still holds true. Install this modification at your own risk but you better make sure you have a usable backup copy of the database because this modification doesn't interact with MySQL properly.

I would avoid it at all costs and go for the paid versions that this tries to circumvent. Although we all have to start somewhere I will never download such a modification (one supposed to be extremely advanced) from a first time developer.

This is the end to any responses from me.

Totally understanding...But disappointing too...


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

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.01070 seconds
  • Memory Usage 1,787KB
  • 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
  • (4)bbcode_html_printable
  • (8)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