vb.org Archive
Page 5 of 25 « First 34 5 6715 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - eCommerce for vB4.2.2+ (https://vborg.vbsupport.ru/showthread.php?t=316501)

Johnny G 01-09-2015 07:42 PM
Quote:
Originally Posted by NickTheGreek (Post 2531484)
I'll see what I can add in the next major release but I'm not promising anything. I don't expect to have more than 15 installations, not because the mod is not good, but because the vBulletin market is so small in nowadays. Even for other very good addons and not so specific in use like this, have no more than 20-25 installations. That said, I'll focus only to add features mainly for my own use, and secondary common for all uses.
I had no idea the audience would be so small! Sorry dude :(

HM666 01-09-2015 10:52 PM
Upgrade did not work. I followed the info in THIS post and uploaded the files & when I went to import the product again I got this database error...

Code:
Database error in vBulletin 4.2.2:

Invalid SQL:
ALTER TABLE usergroup ADD ecommerce INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error  : Duplicate column name 'ecommerce'
Error Number  : 1060
Request Date  : Saturday, January 10th 2015 @ 12:50:25 AM
Error Date    : Saturday, January 10th 2015 @ 12:50:26 AM
Script        : http://lenmkaiser.com/xxxx/plugin.php?do=productimport
Referrer      : http://lenmkaiser.com/xxxx/plugin.php?do=productadd
IP Address    : xxx.xxx.xxx.xxx
Username      : LenKaiser
Classname    : vB_Database
MySQL Version : 5.5.40-cll

TheAdminMarket 01-10-2015 05:38 AM
Quote:
Originally Posted by HM666 (Post 2531559)
Upgrade did not work. I followed the info in THIS post and uploaded the files & when I went to import the product again I got this database error...

Code:
Database error in vBulletin 4.2.2:

Invalid SQL:
ALTER TABLE usergroup ADD ecommerce INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error  : Duplicate column name 'ecommerce'
Error Number  : 1060
Request Date  : Saturday, January 10th 2015 @ 12:50:25 AM
Error Date    : Saturday, January 10th 2015 @ 12:50:26 AM
Script        : http://lenmkaiser.com/xxxx/plugin.php?do=productimport
Referrer      : http://lenmkaiser.com/xxxx/plugin.php?do=productadd
IP Address    : xxx.xxx.xxx.xxx
Username      : LenKaiser
Classname    : vB_Database
MySQL Version : 5.5.40-cll
Don't know how the field ecommerce left out in your user table while the table prefix was wrong before. Connect with phpMyAdmin and remove the field "ecommerce" from your TABLE_PREFIX.user table. Then import the product.

HM666 01-10-2015 06:08 AM
Hmmmm ok I'll do that later on today, gonna get some shut eye right now. :)

TheAdminMarket 01-10-2015 06:52 AM
Quote:
Originally Posted by HM666 (Post 2531622)
Hmmmm ok I'll do that later on today, gonna get some shut eye right now. :)
1.- Just seen that you're not using table prefix. In my opinion this is not wise.
2.- Check the table usergroup and NOT user.

ozzy47 01-10-2015 09:31 AM
Why would it be "not wise" to use a table prefix? I never have used one on any of my sites, and have never ran into a issue.

TheAdminMarket 01-10-2015 11:27 AM
Quote:
Originally Posted by ozzy47 (Post 2531644)
Why would it be "not wise" to use a table prefix? I never have used one on any of my sites, and have never ran into a issue.
Is not a common situation, but it's a situation. There is a big I can say amount of coders who, when they're creating tables (eg user), are using:
Code:
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`....bla...bla...bla......
while professional coders are using:
Code:
CREATE TABLE IF NOT EXISTS `user`....bla...bla...bla......
What's the difference. Let's say that I'm following the first way and in the database there is already a table named "user". My code will drops that table and will create mine. So my script will works (because yes, same names, but structure is almost always different).

You, are following the second way. As you code will see that there is already a table with name "user" will bypass the creation of your code. So your script will not works.

This was very common problem some 10 years ago when Hosting providers were giving just one database in their hosting plans. Now, they're giving many, so most webmasters are using a database per script. If not, they're in risk at some day to try to install a script in the same database having tables with same names.

That's was the reason for exististin of TABLE_PREFIX.

ozzy47 01-10-2015 12:33 PM
That sounds logical. Thanks for the explanation. :)

RichieBoy67 01-10-2015 12:40 PM
Hey Christos! This is outstanding! I am going to use this at some point definitely! Really great work!

HM666 01-10-2015 04:57 PM
Quote:
Originally Posted by NickTheGreek (Post 2531625)
1.- Just seen that you're not using table prefix. In my opinion this is not wise.
2.- Check the table usergroup and NOT user.
Ok that is where I'll check as for the table prefix since this is the only version of vBulletin that I'll be running on this site in this database its not a problem IMO. I had initially installed it as a dev site but have decided to do the site in vBulletin instead of straight web design as I have it now.


All times are GMT. The time now is 09:10 AM.
Page 5 of 25 « First 34 5 6715 Last »
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.01515 seconds
  • Memory Usage 1,746KB
  • 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_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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