Version: 1.0.0, by King Kovifor
Developer Last Online: Aug 2015
Category: Major Additions -
Version: 3.6.5
Rating:
Released: 08-05-2006
Last Update: 08-19-2006
Installs: 20
DB Changes Uses Plugins Template Edits
Additional Files
No support by the author.
vBPortfolio Lite is the "Lite" version of the still in-development full version. This version is completely free.
Features:
Template
Phrases with Custom Phrasegroup
Uses a repeat method for display all entries.
Pagination
Settings
ACP Backend:
Listing
Add
Edit*
Delete*
Reset
Version Check
* ACP backend currently does not work. Bugs have been found that hinder use of this feature, but the rest is stable.
Known Bugs:
There are two bugs that haven't been touched. There is one bug that is partially complete and needs some tweaking. The page navigation has been completely rewritten to include less code and better performance.
Patch Released
For an immediate fix for users with entries not showing up when they are added a patched portfolio.php has been uploaded. To install the patch version please overwrite the portfolio.php file on your server. Than in your vBPortfolio settings, please turn pagination OFF. (set this setting to no)
When installing, this will add 2 plugins and add a 1 entry into a mysql table, and add 1 table.
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.
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.
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