vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)
-   -   viPortfolio 1.2.6 Beta Release (https://vborg.vbsupport.ru/showthread.php?t=41691)

Kars10 08-13-2002 06:01 AM

Well APOK, if you read the last Posts, you will find exactly the problems you tell us here and the answers....;)

Martin64 08-13-2002 10:56 AM

Quote:

Originally posted by Apok2002
Well, I've been trying like a mad man for the past few days to install this one. It's just kickin' my arse. The auto-install isn't working for me, so I'm trying the manual install.

However...the following sql query exec is not working.

When I run that thru myphpadmin, this is what I get:

Error
SQL-query :

SELECT MAX(DISPLAYORDER) FROM SETTINGGROUP LIMIT 0, 30

MySQL said:


Table 'apok_vbp.SETTINGGROUP' doesn't exist

I've tried the exec w/ and w/o the ";" at the end of SETTINGGROUP, no change. Also, I've installed the tables correctly...still nothing.

I have other issues...but I figure this is stumper and may has well tackle them one at a time. Can anyone help?

It is "settinggroup", not "SETTINGGROUP". Lowercase :)

Try this instead:

Code:

SELECT MAX(DISPLAYORDER) FROM settinggroup LIMIT 0, 30

TeddyBare69 08-13-2002 03:45 PM

Very important, in version 1.1.0 DO NOT RUN the upgrade......

Do an install instead. There is a bug that will delete all of you forum settings. If I am too late on this for anybody tell me and I will do everything I can to help you fix your settings.

PLEASE do a backup before ANY and ALL hack installs

TeddyBare69 08-13-2002 04:33 PM

Sorry if I scared anybody. I got it fixed now. I had found the bug prior to uploading it and had fixed it, so I thought :rolleyes:

This time I made sure :nervous:

In the process I fixed the installation of the settings so now when you install or upgrade it will have the settings setup correctly. One note though. Currently if you upgrade, any changes to the settings will be deleted. Any changes made to the templates will also be deleted. I am trying to figure out a good way to know if there are any modifications done before I start updating. Its harder than it sounds :(

I will do my best not to post anymore messages like the previous. Again, thanks for your support! :classic:

Apok2002 08-13-2002 07:00 PM

Well, I used the upgrade before your last 2 posts. Is the correction in that download? Or did you re-upload the files AFTER you had already submitted the 1.10?

Also, I think I will have to just do a complete uninstall, then install manually.

TeddyBare69 08-13-2002 07:13 PM

Hey Apok2002,

If you give me a couple hours, I have some more really good fixes for the installer. I just need a little more time for testing.

I have two questions for you. Since you went thru the upgrade.
1. Please tell me you either backed up prior or are installing on a test forum that means nothiing to you :fingerscrossed:

2. Have you gone into the admin control panel and seen if you have your settings for your forum?

Let me know were you are at? :(


I have been fixing most all of the bugs that you and others have reports. I have to fix the permission bug next. and then the major ones will be gone.

Just know I appreciate your help. I hope this isn't too frustrating for you all.

Apok2002 08-13-2002 07:37 PM

I have a backup from several days ago. :( But on a side note, I don't see any forum setting changes now....even after the update. What kind of settings are you referring to that were supposed to be affected?

Also, there are NO settings in the Admin CP for viPortal. My AdminCP Forum settings area seems to be fine. Nothing changed, nothing broken.

Warrior 08-13-2002 08:34 PM

I just want to add a few things here :ermm: :

The viPortfolio is good to go. It is an outstanding addition for your members to display images and other files. And after v1.1.0 the portfolio pages now load many times faster because the thumbnails went from HTML resize to a 3k crop. And still with no ImageMagick required.

This IS A BETA forum. :tired: Please do not install on an active board unless you totally understand the risks and have backed your board up right before.

We have been running viPortfolio on our site for a few weeks and have ironed out any serious bugs. The biggest thing right now is this installer. And because this hack requires db tables to be created, PHP and template edits, it has taken some time to finish...

Thanks for all your installs and help thus far. We would like to hear from anyone who has set up a test board of < 2.2.6 versions so we can measure the earlier compatibility.

Apok2002 08-14-2002 05:09 AM

OK...I'll work with it more tomorrow or the next day or so. But on a side note...I know this is merely a portfolio...and it's a great one btw...perhaps the best I've seen! But what about somehow incorporating it as a gallery as well...so that all those who have a portfolio, can be listed in a public gallery..say using their first pic as their thumbnail for their particular gallery.

I know there are other galleries out there...but I think this has the potential to top them all. Esp since it can display so many different media types and it IS a quick loader of images/media.

Any plans for this type of integration?

Warrior 08-14-2002 05:34 AM

Having a page for random uploads from the db is a good idea. We will need these ideas for our second version.

Because this is v1.x.x, more is sure to come once we get this installer polished off and the first version is out the door. TeddyBare69 is integrating a version control system to help with future upgrading.

A gallery would be great. A random table mixture of all the the users uploads with the descriptions. A group portfolio - perhaps even by usergroups. We'll take notes once this one leaves the BETA forum and graduates to the Full Release Forum. Which should be soon due to the good feedback so far...

Warrior 08-14-2002 06:48 PM

The installer will now use Chen's vbHacker as an install option to make it really easy. If you do not have this - you can get it here:

vbHacker :banana:

TeddyBare69 08-14-2002 07:58 PM

You heard it right here first! As an added convience to our fellow hackers/hackettes we have added support for Chens illustrious vbHacker. This is a pretty impressive hack all in itself. So now, if you have had troubles in the past getting the Paperclip or Profile hack to work, this might be your ticket in. :D I am still working on the permissions problem or atleast determining there is a permission problem and handling it appropriately. I wanted to get this out as quickly as possible though.

TeddyBare69 08-15-2002 03:50 AM

I have finaly fixed the permissions problems when copying files. Now either the install.php file can fix the permissions for you or it will pause the install and tell you what permissions it needs changed. I hope this helps.

Apok2002 08-15-2002 04:54 AM

I tried to run the install program (I deleted all previous tables and files) to get this set up again. While trying to install tables, it said:

Creating tables...

The script reported errors in the installation of the tables. Only continue if you are sure that they are not serious.

The errors were:

Error number: 1064

Error description: You have an error in your SQL syntax near '; ' at line 1

Here is the full sql query:


No full sql query was given.

TeddyBare69 08-15-2002 06:30 AM

Looks like my gremlins attacked me again :angry:

I have uploaded a new version that should fix that problem for good. I took my arc welder out and made sure that piece of code would stay in there this time! :eek:


The vbHacker addition is the last part of the install. I have included that for the purposes of modifying the existing templates and source code files. With all the SQL code and templates that I had it was easier to only have part of the install be handled by vbHacker.

The error you got with the ';' problem. Have you seen that error before? I am trying to figure out what causes the error. I have the same problem on my production server but not on my test server. I want to make my test server have the same requirement since most people are setup that way.

Apok2002 08-15-2002 04:35 PM

lol Bear...ok, I'll try it again. And no, I've NEVER had a ";" issue before...and I have about 20 hacks or so installed that work just fine that hav never receieved that error.

TeddyBare69 08-15-2002 05:02 PM

somebody has had to have seen it before. I seem to have the error coming up on everybodies database but mine!

TeddyBare69 08-16-2002 11:43 AM

Apok2002,
I was just going over the past posts and noticed that I never responded to your idea. To expand this portfolio into a gallery. That would be cool. Could have different groups by the file type/file owner/update date/etc... I also would like to incorporate a software package called CVS. Concurrent Versioning System. This would allow for multiple versions of the same document with maximizing the storage by only storing the diferences between the old file and the new file.

Just an endless list of wants....:D

I think I will get this out of Beta first though. How did you install go? :fingerscrossed:

Warrior 08-16-2002 10:32 PM

We need at least one Beta installer on here with a successful install. The download is updated and in our latest bug-free environment - unless someone comes up with one.

Please note: the installer has change to a much easier interface since 1.1.x.

Thanks for everyone who has helped us get this past Beta - I know there are a lot of forum owners that could use this hack.

BTW, we never posted the user cp screen shot. Here it is:

Apok2002 08-17-2002 06:34 AM

Quote:

Creating tables...




The script reported errors in the installation of the tables. Only continue if you are sure that they are not serious.

The errors were:

Error number: 1064

Error description: You have an error in your SQL syntax near '; ' at line 1

Here is the full sql query:
Using the installer, I got the same error. What is the 'work around' other than using manual install?

TeddyBare69 08-17-2002 02:32 PM

ok now this is starting to bother me!

I posted this issue on the hackers help forum. So far there hasn't been any conclusive thoughts but I did have a comment form Dark_Wizard, he also says that his database had a problem with these same files also and did this same fix and it worked for him.

I got my fingers crossed on this one. Sounds like it could finaly work for ya.

I am sending you the updated viPortfolio/database/ files. Take the attached zip file and extract the contents into the viPortfolio/database/ directory on your server. this will overwrite all the files in that directory.

Now you can go ahead and rerun the install.

These fixes will also be in version 1.2.3 and above.

Apok2002 08-17-2002 03:59 PM

Did that...and got the EXACT same message. No change.

Apok2002 08-17-2002 04:03 PM

Should any of the files be a certain CHMOD that may not be when I upload them?

Dark_Wizard 08-17-2002 04:31 PM

Quote:

Originally posted by Apok2002
Did that...and got the EXACT same message. No change.
It wouldn't create the tables? What version of PHP and MySQL are you using?

Apok2002 08-17-2002 05:05 PM

PHP 4.2.1

Mysql 3.23.45

And yes...it would not get past stage 1 of install...tables could not be created.

TeddyBare69 08-17-2002 06:05 PM

Apok2002,
This was definately not in the plans. Did you not read the plans before we started this beta testing. The errors can last more than three days. Your time is up.

I am going to go and fix the error reporting in the install script. Unless I see something that shouts out error there won't be any fixes in the version I send up. It will hopefully just give more exact information about the problem it is having. taht will be posted within the next hour.

For any body else. If you are recieveing the same error you are more than welcome to run this new install and see if you get the same reponses as everybody else. I would really love to find this bug and (Politicaly Correct of course) squash its guts out!

Be back in a bit

Apok2002 08-17-2002 06:26 PM

When running:

Quote:

select settinggroupid, title from settinggroup where title like 'viPortfolio%';
I get 2 usergroups, #'s 45 and 46. So I'm assuming it's safe to use "47" as the high number?

Apok2002 08-17-2002 06:29 PM

yayyyy! Admin settings finally showed up. But...They are listed 2x. I'm assuming this may have to do somethingw/ my above post. How do I remove one of those entries for viPortfolio Settings in the admin cp?

TeddyBare69 08-17-2002 07:05 PM

So you found two entries in the settinggroup table called 'viPortfolio Settings'. One of those settinggroupids you used to assign to the settings in the setting table.

I am going to pick 46 for this example. That would make 45 an extra row.

delete from settinggroup where settinggroupid = 45

This will get rid of the extra row.

This presents me with a question though. How are you getting the settings in the table but not able to create other tables? Is there a permission problem or something that you have on your database? I am guessing you have already validated that. How are you getting the settings into the database. executing something like below:

\. install_settings.sql

from a mysql prompt or

mysqladmin install_settings.sql

from a command prompt?

Either way, I have attached the new install file with the addtional debug messages in it. We should now exactly what, were, why, and who to shoot after you run this.

Thanks

Apok2002 08-17-2002 07:41 PM

I'm using myphpadmin. I will open install_settings.sql in a web browser/text editor, then copy/paste into myphpadmin.

Perhaps that is the cause? It's the only way I know how to.

TeddyBare69 08-17-2002 09:32 PM

Apok,
Did the new install give the same errors? I seen one or two places in the install program that were possible bug hideouts until I crushed them. :D I am hoping all you get is a bunch of debuggin messages and a have a nice day message :D

Inquiring minds want to know .

Apok2002 08-17-2002 09:58 PM

Getting closer. I only got this error:

Quote:

Notice [1024] Could not copy file /home/apok/public_html/forums/viPortfolio/viIcons/blank.jpg to /home/apok/public_html/forums/images/viIcons/blank.jpg

Warning message on line 712 of file /home/apok/public_html/forums/viPortfolio/install.php , PHP 4.2.1 (Linux)


viIcons/blank.jpg to /home/apok/public_html/forums/images/viIcons/blank.jpg
I then went to the Control Panel...and the box w/ the link for Edit Portfolio is all black (can't see the link). And when you click it, you get a page not found error.

You get this error when you try to edit your portfolio via your profile:

Quote:

Parse error: parse error, unexpected $ in /home/apok/public_html/forums/member.php on line 1490
There weren't any other errors that were displayed during the install. And I installed the Paperclip and Profile hack via vbhack

TeddyBare69 08-17-2002 10:52 PM

I have some workarounds for you. These fixes are here but in the full download. If you were to get the 1.2.3 version those errors would be gone.

first workaround: :D
edit member.php

go to the very bottom of the file you should see this:
// parse this next line with eval:
$sendtoname=$destuserinfo[username];
eval("standardredirect(\"".gettemplate("redirect_s entemail")."\",\"usercp.php?s=$session[sessionhash]\");");
}
?>

You are supposed to have another } above the ?>. Insert the } on the line before the ?> so that you have:

// parse this next line with eval:
$sendtoname=$destuserinfo[username];
eval("standardredirect(\"".gettemplate("redirect_s entemail")."\",\"usercp.php?s=$session[sessionhash]\");");
}
}
?>

About your link in the control panel being black.

I am going to have to look into that a little further. Can you get the link that menu choice points to? I think if you float over the link you should be able to see were it points to. If you have to type it I don't need the ?s=1235098274350943 stuff. mine points to http://{mysite}/dev1/admin/options.php?t=0#settinggroup36

that is after I took out the session information, ?s= stuff

TeddyBare69 08-17-2002 10:54 PM

We need to give a Humungous thank you to Dark_Wizard. He took one look at my code and new I should be applying at burgerking come monday. :D

Thanks for the eagles eyes Dark_Wizard, that was a great catch on figuring out what was wrong!

Apok2002 08-17-2002 11:55 PM

Uninstalling, and will do a clean install of the latest version. :) We're gonna get this damnit! lol

If it gives probs w/ the usercp again, I'll post it. It was definately the usercpnav template. Also, the black box appeared again in the member profile where Posts were. You couldn't see how many posts there were. I'll make a screen shot if it happens again.

*crosses fingers*....

Apok2002 08-18-2002 12:05 AM

ack! It went back to the first error above:

Quote:

Creating tables...




The script reported errors in the installation of the tables. Only continue if you are sure that they are not serious.

The errors were:

Error number: 1064

Error description: You have an error in your SQL syntax near '; ' at line 1

Here is the full sql query:

It's the semicolon error again. I can use the install.php update that you posted earlier..but I was under the impression that it was included in this .zip file. I'll wait for your response before I proceed.

Apok2002 08-18-2002 04:18 AM

Installed 1.2.5 fine...but....when I try to access anyone's profile...I get this error:

Quote:

Parse error: parse error, unexpected $ in /home/apok/public_html/forums/member.php on line 1490
I also get that above error, for the 1st 4 options in the the User CP.

The Edit Portfolio link returns w/ a Page not Found error. This is the url it tries to go to:

Quote:

http://www.ez-company.net/forums/viPortfolio.php?action=edit
(aslo, the black box appears again, I'll post a screen shot)

The black box aslo appears in the Member list where the Posts column appears.

And the columns are incorrect in the member list (screen shot coming).

Also, the viPortfolio.php file was never installed, I manually uploaded it.

EDIT
After I uploaded the viPortfolio.php file, I was able to edit the Portfolio via the darkened link in the UserCP. This was the ONLY change however. All of the other mentioned bugs are still there.

Apok2002 08-18-2002 04:47 AM

Here is the memberlist. See how the catagories are all misaligned? Also, the last column is blackened...how do I fix?

memberlist.JPG removed...

Below is the UserCP. The first 4 options don't work (they give you the error mentioned above). Also, the last column is darkened. I have 3 themes to select from on my site...however, since I can't access the Options, I can't select a different theme to see what they look like.

usercp.JPG removed....

EDIT

I removed the pics since I changed servers. If you want them back up Teddy so you can reference what I'm talking about I can upload them and link them to the new server, np.

Apok2002 08-18-2002 04:57 AM

Making some progress though. Earlier I had thought that all the options in the UserCP didn't work. I was wrong. The last 4 do work. Including Edit Portfolio (the darkened box).

Here is a ss of it. How do we get rid of all the Q's?

portfolio.JPG removed... (see above post)


EDIT

Also just noticed, that the viPortfolio Settings in the AdminCP do not show. The link for them is there...but when you click on it...it takes you down the page where they SHOULD be...but there is nothing there except the catagory name "viPortfolio Settings" followed by the Save Changes and Reset buttons.

TeddyBare69 08-19-2002 04:21 AM

I am looking into these issues. I should have some fixes as early as monday.


All times are GMT. The time now is 10:52 PM.

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.01390 seconds
  • Memory Usage 1,846KB
  • 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
  • (1)bbcode_code_printable
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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