vb.org Archive
Page 4 of 5 « First 23 4 5
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - vBPortfolio Lite (https://vborg.vbsupport.ru/showthread.php?t=123156)

egtrix 01-06-2007 07:56 PM
I add entries but they don't show in the portfolio page, and even when I edit these enteries from the admincp, the name of the entry is there but the other feilds show as empty ones although that I filled and saved them earlier.
Also when trying to delete an entry, no errors show but nothing happens, the entries are not deleted.

King Kovifor 01-07-2007 01:35 PM
A new version is ready, but not with the phrases so here's a patch. THis should fix all problems.

thincom2000 01-10-2007 02:17 AM
Quote:
Originally Posted by y2krazy
I get this when trying to import the product on 3.6.0 Gold:

Code:
Database error in vBulletin 3.6.0:

Invalid SQL:
CREATE TABLE `portfolio` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`link` VARCHAR( 100 ) NOT NULL ,
`site` VARCHAR( 100 ) NOT NULL ,
`start` VARCHAR( 100 ) NOT NULL ,
`finish` VARCHAR( 100 ) NOT NULL ,
`screen1` VARCHAR( 1000 ) NOT NULL ,
`alt1` VARCHAR( 1000 ) NOT NULL ,
`screen2` VARCHAR( 1000 ) NOT NULL ,
`alt2` VARCHAR( 1000 ) NOT NULL ,
`description` VARCHAR( 10000 ) NOT NULL
) ENGINE = MYISAM ;;

MySQL Error : Too big column length for column 'screen1' (max = 255). Use BLOB instead
Error Number : 1074
Date : Saturday, August 12th 2006 @ 09:23:27 PM
Script : http://www.transitracing.com/admincp...=productimport
Referrer : http://www.transitracing.com/admincp...?do=productadd
IP Address : *****
Username : Thermo.
Classname : vb_database
I don't think this was touched on, but the reason this happened is because VARCHARs larger than 255 are not supported unless your server runs MySQL 5. Once everyone starts running 5, we can stop using BLOBs. I prefer LONGTEXT myself, since for some reason I can never use any string functions like explode() or str_replace() on a BLOB stored in a string, the string just gets set equal to ''

Also, I got excited when it sunk in that I upgraded to PHP 5, but then also realized I wouldn't be able to write hacks with any of the new functions if I expected to post them here and have the code work for most people.

But I also had an XML error that made no sense why it wasn't creating my database. I just deleted most of the file and started over, since after 2 days I couldn't find the syntax error. vBulletin wasn't reporting it during Product Installation, and it remained hidden even after using $db->show_errors();

This error had just reminded me of all that. Sorry, guys.

King Kovifor 01-10-2007 06:18 PM
It's ok... We told them what to do.... i think (i hope!)

Killer_Charge 10-04-2007 06:44 AM
I have uploaded the files to my forum, and added the fix, but i still get an error with the pagenation on
Code:
Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT * FROM portfolio LIMIT ,;

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 '' at line 1
Error Number : 1064
Date        : Thursday, October 4th 2007 @ 09:43:20 AM
Script      : http://www.erixx.co.uk/forums/projects.php
Referrer    :
IP Address  : 62.171.194.9
Username    : Administrator
Classname    : vb_database
if i turn the pagenation on, it has no error, but no entrys show
please help :D

King Kovifor 10-06-2007 01:13 AM
You have to turn it off. It was fixed in an unreleased version... I probably should finish that...

Killer_Charge 10-08-2007 01:55 PM
it is turned off and gives that error :(

King Kovifor 10-08-2007 02:28 PM
Um. I think there is a fix earlier in the thread. I will find one for you in a bit. I currently have some homework to do.

Killer_Charge 10-09-2007 04:20 AM
ok thanks

King Kovifor 10-09-2007 11:13 PM
Quote:
Originally Posted by Killer_Charge (Post 1356020)
ok thanks
It seems that I never provided a fix. How many entries do you plan on having?


All times are GMT. The time now is 02:10 AM.
Page 4 of 5 « First 23 4 5
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.02370 seconds
  • Memory Usage 1,738KB
  • 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
  • (2)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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