Major Additions - vBPortfolio Lite

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.

[egtrix]

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]

A new version is ready, but not with the phrases so here's a patch. THis should fix all problems.

[thincom2000]

Originally Posted by y2krazy

I get this when trying to import the product on 3.6.0 Gold:

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]

It's ok... We told them what to do.... i think (i hope!)

[Killer_Charge]

I have uploaded the files to my forum, and added the fix, but i still get an error with the pagenation on

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

[King Kovifor]

You have to turn it off. It was fixed in an unreleased version... I probably should finish that...

[Killer_Charge]

it is turned off and gives that error

[King Kovifor]

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]

ok thanks

[King Kovifor]

Originally Posted by Killer_Charge

ok thanks

It seems that I never provided a fix. How many entries do you plan on having?