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.

[y2krazy]

Anyone able to help out with the fault in the SQL code?

[Mythotical]

y2krazy, check to make sure your server has php updated and mysql updated.

[y2krazy]

These are what my server is running:

PHP version 4.4.2
MySQL version 4.0.27-standard

Is this mod not compatible with these versions?

[King Kovifor]

If that's not working, run this query:

PHP Code:

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( 255 ) NOT NULL ,
`alt1` VARCHAR( 255 ) NOT NULL ,
`screen2` VARCHAR( 255 ) NOT NULL ,
`alt2` VARCHAR( 255 ) NOT NULL ,
`description` VARCHAR( 10000 ) NOT NULL
) ENGINE = MYISAM ;; 


Try running that (and hopefully the install code will be skipped.

Our Test vB has:

4.1.21-standard for MySQL and 4.4.2 for php. It works fine on these. It might be the mysql...

[y2krazy]

Well, that fixed it. Seems that this was the snag in the XML file:

) ENGINE = MYISAM ;");]]></installcode>

Simply remove that little piece and it should work fine.

Also, I wasn't aware of this, but is this mod just for the owner of the site it's used on to utilize, or is it editable on a per-user basis?

EDIT: That didn't fix the SQL. It never made the 'portfolio' table and when I tried to run that query in phpMyAdmin, this it what it gave me:

#1074 - Too big column length for column 'description' (max = 255). Use BLOB instead

[mac27]

OK but where do you find the portfolio at. I know it is there but where.

[King Kovifor]

Originally Posted by y2krazy

Well, that fixed it. Seems that this was the snag in the XML file:

) ENGINE = MYISAM ;");]]></installcode>

Simply remove that little piece and it should work fine.

Also, I wasn't aware of this, but is this mod just for the owner of the site it's used on to utilize, or is it editable on a per-user basis?

EDIT: That didn't fix the SQL. It never made the 'portfolio' table and when I tried to run that query in phpMyAdmin, this it what it gave me:

#1074 - Too big column length for column 'description' (max = 255). Use BLOB instead

I was hoping that it didn't do that. You'll need to do this instead:

PHP Code:

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( 255 ) NOT NULL ,
`alt1` VARCHAR( 255 ) NOT NULL ,
`screen2` VARCHAR( 255 ) NOT NULL ,
`alt2` VARCHAR( 255 ) NOT NULL ,
`description` VARCHAR( 255 ) NOT NULL
) ENGINE = MYISAM ; 


Also note, that the table prefix is not in there. If you have vb_ as your table prefix change "portfolio" to "vb_portfolio" and it'll correctly integrate.

Yes, this mod is for the Owner only. Or at least anyone with access to the ACP.

Originally Posted by mac27

OK but where do you find the portfolio at. I know it is there but where.

After you install the mod, and upload the files go to the following URL:

http://www.domain.tld/forum_directory/portfolio.php

That is if you didn't rename that.

[y2krazy]

Alright, I replaced the table with that last SQL and now I go to try and save an entry in the ACP and once I hit Save, it redirects and shows it as an entry; however, when I went to view it @ /portfolio.php nothing shows up. So, I checked back in the ACP and clicked [EDIT] and when I do, all the fields are blank and when I check phpMyAdmin, the data was entered into the database correclty as the first row.

What would explain nothing showing up in the ACP or on the /portfolio.php page?

[King Kovifor]

[EDIT] and [DELETE] are currently listed as bugs for the ACP. The queries are not running which is causing no data to show.

/portfolio.php should show all of them. Do you have it installed on a test board? If so, could you show me the query that selects from prefix_portfolio table? Any of them will that include that would be useful.

[y2krazy]

I am running on somewhat of a test board I guess - ie, it's not open to the public yet (forum is locked), but I haven't edited any files from the version you released so I have what you have.