vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   4images Gallery 1.7 + vB 3.0.x (update Oct 30) (https://vborg.vbsupport.ru/showthread.php?t=66335)

Blam Forumz 08-05-2004 10:25 PM

Quote:

Originally Posted by Blam Forumz
I'm getting this error :

Code:

DB Error: Bad SQL Query: SELECT template FROM template WHERE title='options'
Table 'blamina_4Img1.template' doesn't exist

DB Error: Bad SQL Query: SELECT sessionhash, lastactivity, host, userid FROM session WHERE sessionhash = '499eb95af60bba8a0622fc347dafbe04' AND host = '81.155.5.216'
Table 'blamina_4Img1.session' doesn't exist

DB Error: Bad SQL Query: SELECT sessionhash FROM session
Table 'blamina_4Img1.session' doesn't exist

DB Error: Bad SQL Query: SELECT sessionhash FROM session WHERE sessionhash = '133a211366c69ffd6dbfbcca5837c3ee'
Table 'blamina_4Img1.session' doesn't exist

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/blamina/public_html/forum/album/includes/db_mysql.php on line 164

DB Error: Bad SQL Query: INSERT INTO session (sessionhash, userid, host, useragent, lastactivity, location, styleid) VALUES ('133a211366c69ffd6dbfbcca5837c3ee', 1, '81.155.5.216', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7) Gecko/20040626 Firefox/0.9.1', 1091649604, '/album/index.php', '0')
Table 'blamina_4Img1.session' doesn't exist

Warning: Cannot modify header information - headers already sent by (output started at /home/blamina/public_html/forum/album/includes/db_mysql.php:188) in /home/blamina/public_html/forum/album/includes/sessions.php on line 111

Warning: Cannot modify header information - headers already sent by (output started at /home/blamina/public_html/forum/album/includes/db_mysql.php:188) in /home/blamina/public_html/forum/album/includes/sessions.php on line 111

Warning: Cannot modify header information - headers already sent by (output started at /home/blamina/public_html/forum/album/includes/db_mysql.php:188) in /home/blamina/public_html/forum/album/includes/sessions.php on line 111

DB Error: Bad SQL Query: SELECT s.userid, s.lastactivity, s.host, u.userid, u.usergroupid, u.username FROM session s LEFT JOIN user u ON (u.userid = s.userid) WHERE s.lastactivity >= 1091647804 ORDER BY u.userid ASC, s.host ASC
Table 'blamina_4Img1.session' doesn't exist

Parse error: parse error, unexpected '<' in /home/blamina/public_html/forum/album/includes/page_header.php on line 274

Help please, I use vBulletin 3.0.2 and I use the latest 4Images


Bump

Steph2k 08-05-2004 10:42 PM

Quote:

Originally Posted by edeab220
I'm a little confused about 4images...

It says in the requirements that prior to installing 4images from this thread I need 4images 1.7 installed. Where do I get this other version, and is that really necessary?


I think what they mean is that you need to have a fresh install of 4images. What is attached in this thread is simply the edits that you need to do to make this hack work as well as file replacements. Go here to get 4images 1.7 and install it, then use the contents of the zip file attached in this thread to install the hack to integrate vbulletin with 4images..

Dont know if that was the answer you were looing for but that was my interpretation of your question :)

Steph2k 08-06-2004 04:35 AM

Quote:

Originally Posted by clio
Hi mtha, I ended up just hard coding the URL in and removing the variable from the template.

But now, I have another problem, a cookie problem.

It's recognizing that I've logged in. But I can't get into the admin.

This was working a when I just installed it about a week ago.

Now, I goto my album:
http://www.learntoquestion.com/class/travels/photos/

and when I login, the form doesn't recognize that I've already logged in and continues to display the login form. It does the same when I try to get into the admin.

Any ideas?

Edit:
This is really weird. Right now it's not working in Safari (1.2.2), a browser for the Mac. I just tried it in Netscape 7.1 for the Mac and it works perfectly fine. WEIRD. Any ideas why?

I'm having the same problem as well.. can't log into admin with vB3.0.3 +4images using IE6 (I know I was able to prior to installing this hack cuz I logged in to check the usergroup IDs to make sure they matched). I just tried in mozilla 1.6 and was able to log ins .

dotcomguy 08-06-2004 04:26 PM

Quote:

Originally Posted by Blam Forumz
Code:

DB Error: Bad SQL Query: SELECT template FROM template WHERE title='options'
Table 'blamina_4Img1.template' doesn't exist


I was having that problem also, but I found a solution. Add the following line to constants.php:

PHP Code:

define('VB_TEMPLATE_TABLE'VB_TABLE_PREFIX.'template'); 

For the other errors, I suggest you double check the table names in constats.php, and also make sure you have the prefix set correctly if you are using a prefix.

Blam Forumz 08-06-2004 04:33 PM

Where about sin constants.php do i add it? at the end?

Edit - whats a prefix? excuse my naiveness please

dotcomguy 08-06-2004 04:40 PM

Quote:

Originally Posted by Blam Forumz
Where about sin constants.php do i add it? at the end?

Edit - whats a prefix? excuse my naiveness please

No worries. :)

You can add it anywhere in constanst.php. There are a few lines similar to that under "// Table names". I just added it there. I suppose the author left that out in the documentation.

The prefix is the table prefix you may have specified when you installed vBulletin. My prefix is "vb3_" for example. It allows you to use a prefix on all tables vBulletin uses in the database. This is helpful if you have other tables in the database because you can easily differentiate between vBulletin tables and other tables and also prevent naming conflicts.

Blam Forumz 08-06-2004 04:43 PM

Ok, i've checked all of it, still getting the same bloody error :(

Should I re-install 4Images and see if it makes a difference? or should I just go and use the coppermine ones? which im also getting an error might i add

deathemperor 08-12-2004 04:33 AM

hello mtha,
I'd like to have the 4images images display ramdomly in the forumhome, I'm a n00b so please help me with the code ^^
tnx

ImportPassion 08-14-2004 03:53 AM

Quote:

Originally Posted by Blam Forumz
Ok, i've checked all of it, still getting the same bloody error :(

Should I re-install 4Images and see if it makes a difference? or should I just go and use the coppermine ones? which im also getting an error might i add

don't know if u still need this, but in sessions.php find

define('VB_TEMPLATE_TABLE', 'template');

and relpace with

define('VB_TEMPLATE_TABLE', '**vb_prefix**template');

replace **vb_prefix** with whatever the characters are in front of your template table in vb.

deathemperor 08-18-2004 02:57 AM

Quote:

Originally Posted by deathemperor
hello mtha,
I'd like to have the 4images images display ramdomly in the forumhome, I'm a n00b so please help me with the code ^^
tnx

anyone ?

arpy 08-21-2004 09:06 PM

Ok, I installed 4images and this hack today but I didn't get the "single" login running. When I was changing from board to gallery, often I was logged out. I did some investigation and found and error(?)

PHP Code:

      if ($this->read_cookie_data(COOKIE_PREFIX."password") == md5($this->user_info['user_password'].''VBLICENCE_NUMBER) && $this->user_info['user_level'] != USER_AWAITING) {
        
$this->set_cookie_data(COOKIE_PREFIX."password"$this->user_info['user_password']);


Does this make sense? If the cookie-PW equals to profileDB-PW*MD5 then replace the Cookie with the PW without MD5???

I have removed the set_cookie statement and now everything seems to be fine...but to be honest, I'm not really sure because nobody else had problems ;)

arpy

[high]* arpy Clicks install ;)[/high]

boiboi 08-25-2004 05:31 AM

Quote:

Originally Posted by mtha
I dont see the relationship here, but ... well maybe there's some conflict ... I have no idea what it should be yet.

Just installed this hack yesterday. This error seems unsolved in this thread but here it is again:

When I replace the following in forum/includes/function.php
<search for>
$name = COOKIE_PREFIX . $name;
</search for>
<replace>
if ($name != 'sessionhash')
{
$name = COOKIE_PREFIX . $name;
}
</replace>

This error shows up:

Parse error: parse error in /home/initial/public_html/forums/includes/functions.php on line 1864

Line 1864:

$debughtml .= " (<a href=\"" . htmlspecialchars_uni(SCRIPTPATH) . iif(strpos(SCRIPTPATH, '?') '?')=== false, '?', '?','&amp;') . "tempusage=1\">Template Usage</a>) (<a href=\"" . htmlspecialchars_uni(SCRIPTPATH) . iif(strpos(SCRIPTPATH, '?') '?')=== false, '?', '?','&amp;') . "explain=1\">Explain</a>)<br />\n";

It seems like it's totally unrelated, but it's not.

BlackxRam 08-26-2004 06:13 AM

First you guys. This hack right now is perfect unless you have changed the NAME of your COOKIES FOR VBULLETIN. IF you do that, go back and search this thread for the fix he gave me.

Second, this hack only integrates the LOGIN SYSTEMS... not the functionality of it. REMEMBER THAT LOL.

If your trying to get 4images to appear on vbulletin then this is not the hack your looking for. This hack will only allow you to use your vbulletin login on 4images. This hack is mainly on the 4images side. If there are any errors its probably your own fault NOT this hack. This hack is perfect if your using VB 3.0.1 and up. I have now installed this mod on over a dozen installations.

Start over, and work at it SLOWLY and it will work for you. If yout not accustomed to working with 4images then you shouldnt have tried installing this hack right now. Try some smaller hacks over at 4homepages.de to get used to the pages you will be editing.

BlackxRam 08-26-2004 06:16 AM

Quote:

Originally Posted by Blam Forumz
Bump

Blam, I have no idea what you did but you didnt install it properly. Start over with clean files. Work it through step by step. usually a BUNCH of errors like that means you didnt upload the sessions.php file to the 4images includes folder or you messed up that file. there is only ONE CHANGE OF VBULLETIN and thats in the INCLUDES/functions.php file. Thats the only thing you change on vbulletin. Everything else is 4images related.

BlackxRam 08-26-2004 06:18 AM

Quote:

Originally Posted by deathemperor
anyone ?

Death, this hack is for integrating the login systems not putting images on another page. There is a hack on 4homepages.de that outputs the latest additions to a page on your website. You can use that and the phpinclude template of vbulletin to add your images. Either that, or request a hack in the requests forum. This thread is the wrong place for that.

boiboi 08-26-2004 08:14 PM

Quote:

Originally Posted by boiboi
Just installed this hack yesterday. This error seems unsolved in this thread but here it is again:

When I replace the following in forum/includes/function.php
<search for>
$name = COOKIE_PREFIX . $name;
</search for>
<replace>
if ($name != 'sessionhash')
{
$name = COOKIE_PREFIX . $name;
}
</replace>

This error shows up:

Parse error: parse error in /home/initial/public_html/forums/includes/functions.php on line 1864

Line 1864:

$debughtml .= " (<a href=\"" . htmlspecialchars_uni(SCRIPTPATH) . iif(strpos(SCRIPTPATH, '?') '?')=== false, '?', '?','&amp;') . "tempusage=1\">Template Usage</a>) (<a href=\"" . htmlspecialchars_uni(SCRIPTPATH) . iif(strpos(SCRIPTPATH, '?') '?')=== false, '?', '?','&amp;') . "explain=1\">Explain</a>)<br />\n";

It seems like it's totally unrelated, but it's not.


I've installed much more complicated hacks than this. Try vbulletin integrated with Horde framework. I commented out line 1864 now your hack works.

Guz2003 08-27-2004 03:32 PM

I have same problem

boiboi 08-28-2004 05:58 AM

Yeah but this guy thinks it has nothing to do with the hack, so just try commenting out the line I mentioned.

Drache 08-28-2004 09:49 PM

sweet been looking for something like this. I really want to install it but before i do i have 2 question to ask.

1. Does this support vb 3.03?

2. I've checked your http://www.randomforum.com/forums/gallery/index.php it looks really good. but is it possile to have a option that allow you to view all the photo that member posted? Like when you go to their memer details and you will be able to find all photo or image post by that user.

Looking forward to your reply. Thanks

Caiman 08-29-2004 05:33 PM

Quote:

Originally Posted by hongfire
sweet been looking for something like this. I really want to install it but before i do i have 2 question to ask.

1. Does this support vb 3.03?

2. I've checked your http://www.randomforum.com/forums/gallery/index.php it looks really good. but is it possile to have a option that allow you to view all the photo that member posted? Like when you go to their memer details and you will be able to find all photo or image post by that user.

Looking forward to your reply. Thanks

hacks like that can be found in here: http://www.4homepages.de/forum/viewforum.php?f=15

Drache 08-29-2004 07:54 PM

cool thanks for the reply i am checking. and does this hack support vb 3.03?

Drache 08-30-2004 01:33 AM

Sweet noticed the topic updated that answered my question. it supports 3.03.

Quote:

hacks like that can be found in here: http://www.4homepages.de/forum/viewforum.php?f=15
Caiman I couldn't find the hack that allow to people to view all photo that member uploaded in member's album or profile. could you give me the specify link to the hack? thanks :)

Rambo 09-01-2004 03:52 PM

*clicks install*

Everything seems to be in working order,

I am now trying to figure out how to get it to match with my forum skin hehe :P

Bhuwan 09-02-2004 04:07 PM

any idea how to get the header/footer from vbull?

mtha 09-02-2004 09:39 PM

:) Sorry I was traveling around Europe last month, didnt have time to go online for supports.

First come first served

Quote:

Originally Posted by Blam Forumz
I'm getting this error :

Code:

DB Error: Bad SQL Query: SELECT template FROM template WHERE title='options'
Table 'blamina_4Img1.template' doesn't exist
....
It does look like you have a different prefix for your table.

try dotcomguy's suggestion and see if it works
https://vborg.vbsupport.ru/showpost....&postcount=124

Quote:

Originally Posted by Blam Forumz
DB Error: Bad SQL Query: SELECT sessionhash FROM session
Table 'blamina_4Img1.session' doesn't exist

Do you have blamina_4Img1.session table? do you have your VB_TABLE_PREFIX being blamina_4Img1?
Did you change this value in constants.php?
define('VB_TABLE_PREFIX',''); // your vb tableprefix. vB default is blank
Please do check them, and it is VB TABLE PREFIX, it is NOT 4images table prefix .... by the way, did you make correction and upload the new constants.php file to 4images folder?


Quote:

Originally Posted by Blam Forumz
I use vBulletin 3.0.2 and I use the latest 4Images

Which version is the LATEST 4Images you have? It only work for 4images 1.7. It may NOT work for 1.8/


Quote:

Originally Posted by Steph2k
Hi, this is a question for those who have installed 4images. Do you have any cookies issues? That was my biggest complaint with photopost. Never could get the cookies to work with vB. I tried to get help on the photopost forums but it just never worked (they made suggestions but nada). People would have to relogin to the gallery, and then when they got back to the forums relogin there. And then some folks could not even log into the gallery (forum members), which makes the gallery pointless for those people.

So any known cookies/session issues ?

Feedback appreciated. Thanks.

Not such a big problem with my board (even I had complains before). I think I have fixed cookie issues (hopefully :D )

If you do things correctly, you wont have to relogin to gallery (from forum) and vice versa. (however, I did not test will all kind of browsers, so it might still have problems with different browsers. Mine work good with IE, Netscape, Firefox ...

:) maybe you should give it a try :D

Quote:

Originally Posted by clio
Hi mtha, I ended up just hard coding the URL in and removing the variable from the template.

But now, I have another problem, a cookie problem.

It's recognizing that I've logged in. But I can't get into the admin.

This was working a when I just installed it about a week ago.

Now, I goto my album:
http://www.learntoquestion.com/class/travels/photos/

and when I login, the form doesn't recognize that I've already logged in and continues to display the login form. It does the same when I try to get into the admin.

Any ideas?

Edit:
This is really weird. Right now it's not working in Safari (1.2.2), a browser for the Mac. I just tried it in Netscape 7.1 for the Mac and it works perfectly fine. WEIRD. Any ideas why?

I dont know much about MAC ... sorry. Does it work with other browsers/OS?


Quote:

Originally Posted by edeab220
I'm a little confused about 4images...
It says in the requirements that prior to installing 4images from this thread I need 4images 1.7 installed. Where do I get this other version, and is that really necessary?

This is an INTEGRATION between 4images gallery and vBulletin 3.0, it is not a new gallery, as you can see. That's why you have to install vB3 and 4Images first, before doing intagration. Links and information should be in the first post or in the instruction file, or it's http://www.4homepages.de
(thanks steph2k to point this out)


Quote:

Originally Posted by steph2k
I'm having the same problem as well.. can't log into admin with vB3.0.3 +4images using IE6 (I know I was able to prior to installing this hack cuz I logged in to check the usergroup IDs to make sure they matched). I just tried in mozilla 1.6 and was able to log ins .

hehe, IE6 is the latest version, isnt it? mine works fine. Did you check the login part in admin file, and remove "secure login" for 4images?


Quote:

Originally Posted by Blam Forumz
Ok, i've checked all of it, still getting the same bloody error https://vborg.vbsupport.ru/
Should I re-install 4Images and see if it makes a difference? or should I just go and use the coppermine ones? which im also getting an error might i add

You should:
- Have your vB3 forum installed and run properly
- Have your 4images gallery installed and run properly (without applying this hack). Fresh installation recommended
- Read and follow instruction CAREFULLY.

Which gallery (4images or coppermine) you should use, that's your preference. Good luck!

Quote:

Originally Posted by deathemperor
hello mtha,
I'd like to have the 4images images display ramdomly in the forumhome, I'm a n00b so please help me with the code ^^
tnx

There IS a hack in 4images forum to do this. You can go there and find the code.

Quote:

Originally Posted by arpy
Ok, I installed 4images and this hack today but I didn't get the "single" login running. When I was changing from board to gallery, often I was logged out. I did some investigation and found and error(?)

PHP Code:

 if ($this->read_cookie_data(COOKIE_PREFIX."password") == md5($this->user_info['user_password'].''VBLICENCE_NUMBER) && $this->user_info['user_level'] != USER_AWAITING) {
          
$this->set_cookie_data(COOKIE_PREFIX."password"$this->user_info['user_password']);
  } 

Does this make sense? If the cookie-PW equals to profileDB-PW*MD5 then replace the Cookie with the PW without MD5???

I have removed the set_cookie statement and now everything seems to be fine...but to be honest, I'm not really sure because nobody else had problems ;)

arpy

[high]* arpy Clicks install ;)[/high]

password in cookie was encoded twice, that's why you need to encode DB password one more time.
That's how mine work :D anyway, it's good that you find out the solution

Quote:

Originally Posted by boiboi

Quote:

Originally Posted by mtha
I dont see the relationship here, but ... well maybe there's some conflict ... I have no idea what it should be yet.


Just installed this hack yesterday. This error seems unsolved in this thread but here it is again:

When I replace the following in forum/includes/function.php
...
This error shows up:
Parse error: parse error in /home/initial/public_html/forums/includes/functions.php on line 1864

Line 1864:...

It seems like it's totally unrelated, but it's not.

Quote:

Originally Posted by boiboi
Yeah but this guy thinks it has nothing to do with the hack, so just try commenting out the line I mentioned.

Did you have error when install this hack with a fresh version of vB? if it only occures with hacked boards, then I hardly can follow up fixing. If it works when you comment the line out, do it.

Quote:

Originally Posted by hongfire
sweet been looking for something like this. I really want to install it but before i do i have 2 question to ask.

1. Does this support vb 3.03?

2. I've checked your http://www.randomforum.com/forums/gallery/index.php it looks really good. but is it possile to have a option that allow you to view all the photo that member posted? Like when you go to their memer details and you will be able to find all photo or image post by that user.

Looking forward to your reply. Thanks

1. Please read the first port
Hack version: 3.0.1.0625
Compatible vB version: 3.0.1, 3.0.2, 3.0.3. other versions might need minor modifications

2. yes it is posible, but it is not featured in this hack. I think I have mentioned about this once somewhere. Dont remember.

Quote:

Originally Posted by bchawla
any idea how to get the header/footer from vbull?

No. Not for this hack. I wouldnt bother geting header/footer directly from vB.

If you want, you can create a similar header/footer for 4images. It's more template related.

This hack just make 4images and vBulletin work together, not look the same.

it's not too hard to design two template (for forum and 4images) that look the same.

good luck

Demolition man 09-04-2004 04:42 PM

I can log in but i directly log out =/ What can the problem be?

Bhuwan 09-04-2004 10:23 PM

Thnak you for this mod!
but the gallery seems to be extremely slow on loading. any idea how to debug this ?

mtha 09-05-2004 01:47 PM

Quote:

Originally Posted by Demolition man
I can log in but i directly log out =/ What can the problem be?

You meant when you login, you got to the logging in page, but when it comes back to album, you are actually not logged in?

If you read over this thread, I think there're people asking the same thing too.]

The problem would be, you didnt do the integration right. You had the template changed correctly but the files are not correctly setup at some point.

Try to do it agran from a fresh install ... carefully.

Quote:

Thnak you for this mod!
but the gallery seems to be extremely slow on loading. any idea how to debug this ?
The mod has nothing to do with peformance. Did you have your gallery be slow BEFORE having this mod installed?

You should ask over 4images forum for tech support. www.4homepages.de

Demolition man 09-05-2004 06:55 PM

yeah thx i had one problem with functions.php if i eddited it with dreamweaver it crashed my forum but works now

rex_b 09-12-2004 08:42 PM

I'm getting all kinds of errors. I only got past the first 2 steps and I get these..



Quote:

DB Error: Bad SQL Query: SELECT template FROM template WHERE title='options'
Table 'rexb2_4images.template' doesn't exist

DB Error: Bad SQL Query: SELECT sessionhash, lastactivity, host, userid FROM VB_TABLE_PREFIXsession WHERE sessionhash = 'da3fdb67cdd62a7bc0d271ce472ad111' AND host = '68.226.130.51'
Table 'rexb2_4images.VB_TABLE_PREFIXsession' doesn't exist

DB Error: Bad SQL Query: SELECT sessionhash FROM VB_TABLE_PREFIXsession
Table 'rexb2_4images.VB_TABLE_PREFIXsession' doesn't exist

DB Error: Bad SQL Query: SELECT u.*, l.* FROM VB_TABLE_PREFIXuser u, 4images_lightboxes l WHERE u.userid = 3 AND l.user_id = u.userid
Table 'rexb2_4images.VB_TABLE_PREFIXuser' doesn't exist

DB Error: Bad SQL Query: SELECT * FROM VB_TABLE_PREFIXuser WHERE userid = 3
Table 'rexb2_4images.VB_TABLE_PREFIXuser' doesn't exist

DB Error: Bad SQL Query: SELECT sessionhash FROM VB_TABLE_PREFIXsession WHERE sessionhash = 'f918031efd3c2abcc76f3890c2496299'
Table 'rexb2_4images.VB_TABLE_PREFIXsession' doesn't exist

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/rexb2/public_html/4images/includes/db_mysql.php on line 164

DB Error: Bad SQL Query: INSERT INTO VB_TABLE_PREFIXsession (sessionhash, userid, host, useragent, lastactivity, location, styleid) VALUES ('f918031efd3c2abcc76f3890c2496299', 0, '68.226.130.51', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; (R1 1.1); .NET CLR 1.1.4322)', 1095024700, '/4images/index.php', '0')
Table 'rexb2_4images.VB_TABLE_PREFIXsession' doesn't exist

DB Error: Bad SQL Query: SELECT s.userid, s.lastactivity, s.host, u.userid, u.usergroupid, u.username FROM VB_TABLE_PREFIXsession s LEFT JOIN VB_TABLE_PREFIXuser u ON (u.userid = s.userid) WHERE s.lastactivity >= 1095022900 ORDER BY u.userid ASC, s.host ASC
Table 'rexb2_4images.VB_TABLE_PREFIXsession' doesn't exist

DB Error: Bad SQL Query: SELECT DISTINCT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.username FROM 4images_images i, 4images_categories c LEFT JOIN VB_TABLE_PREFIXuser u ON (u.userid = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND c.cat_id = i.cat_id ORDER BY RAND()
Table 'rexb2_4images.VB_TABLE_PREFIXuser' doesn't exist

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.username FROM 4images_images i, 4images_categories c LEFT JOIN VB_TABLE_PREFIXuser u ON (u.userid = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (0) ORDER BY i.image_date DESC LIMIT 3
Table 'rexb2_4images.VB_TABLE_PREFIXuser' doesn't exist

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/rexb2/public_html/4images/includes/db_mysql.php on line 116

mtha 09-12-2004 09:56 PM

Quote:

Originally Posted by rex_b
I'm getting all kinds of errors. I only got past the first 2 steps and I get these..

DID you read and follow ALL steps carefully as in the instruction file?

if you only do first 2 steps, it surely will NOT work.

Quote:

DB Error: Bad SQL Query: SELECT template FROM template WHERE title='options'
Table 'rexb2_4images.template' doesn't exist
This means that you DID NOT give the correct table name for table template.
check this one in your sessions.php

define('VB_TEMPLATE_TABLE', 'template');


Quote:

Table 'rexb2_4images.VB_TABLE_PREFIXsession' doesn't exist
Please DO check your constants.php file for this one:

define('VB_TABLE_PREFIX',''); // your vb tableprefix. vB default is blank

and as it was mentioned in the instruction file:

-------
Step 1.
-------
Edit the included sessions.php
Correct the variables in the Configuration part

-------
Step 2.
-------
Edit the included constants.php
Correct the variables if neccessary.

=> Please do read over the two files and define the variables correctly.

If you have the variables set correct, you wont have the above database problem.


good luck



btw, please DO read over the replies, you will get alot of question answered. Your question was ask and answered in this page:
https://vborg.vbsupport.ru/showthrea...5&page=9&pp=15

rex_b 09-12-2004 11:27 PM

Thanks for the help. I read most of the replies and I did set the variables to my prefix which is "vb3" I will try again later and hopefully it will work.

Just frustrating at times you know..

Thanks again.

Rex

Hoffi 09-13-2004 08:00 PM

I just into the same Problem and there a small misunderstanding in the Doc.

PHP Code:

define('VB_TEMPLATE_TABLE''template'); 

You must enter the Prefix and the Table Name. e.g.

PHP Code:

define('VB_TEMPLATE_TABLE''vb3_template'); 


mtha 09-15-2004 09:25 PM

Quote:

Originally Posted by Hoffi
I just into the same Problem and there a small misunderstanding in the Doc.

PHP Code:

 define('VB_TEMPLATE_TABLE''template'); 

You must enter the Prefix and the Table Name. e.g.

PHP Code:

 define('VB_TEMPLATE_TABLE''vb3_template'); 


PHP Code:

// Define here the name of the template database table.
// Normally no need to change.
define('VB_TEMPLATE_TABLE''template'); 

The default template name is template, and if you have different name for template table (such as vb3_template or anything else), you are told to DEFINE the name of that template table

SnitchSeeker 09-18-2004 08:51 AM

Is there any way to transfer a full and functioning version?

I am using InvisionBoard currently, and have 4images integrated successfully with that. But I am moving over to vb3 (from Invision).

I want to transfer the gallery over without having to re-enter all the images - especially al the members since i have nearly 50,000.

Please tell me this is possible!! :cry: :paranoid:

Maniaz 09-19-2004 12:23 AM

bummer, i tried to install but have got mysql errors :s there on different sub domains but i changed the cookie path in vbb. any suggestions?

http://gallery.yerix.com/index.php?
http://forum.yerix.com

mtha 09-19-2004 07:15 AM

Quote:

Originally Posted by SnitchSeeker
Is there any way to transfer a full and functioning version?

I am using InvisionBoard currently, and have 4images integrated successfully with that. But I am moving over to vb3 (from Invision).

I want to transfer the gallery over without having to re-enter all the images - especially al the members since i have nearly 50,000.

Please tell me this is possible!! :cry: :paranoid:

if you did have your 4images integrated with InvisionBoard, and you have your forum user posting pictures, then this should work fine (theorically)

I did not use IPB nor look at the integration for it, I cant say for sure if it work or not. But I think 4images should have used your IPB user table for users. ... why dont you try to convert your forum to vB, and try the integration (on pre-existing 4images database)? (remember to test and backup first)


Quote:

bummer, i tried to install but have got mysql errors :s there on different sub domains but i changed the cookie path in vB. any suggestions?

http://gallery.yerix.com/index.php?
http://forum.yerix.com
Could you PLEASE READ over the posts above? you will find answers.
and could you please also read the instruction files carefully? it seems that you didnt config the files.

I dont mind answering questions, but I cannot answer the SAME question again and again.

Thanks

Maniaz 09-19-2004 09:18 AM

lol theres 11 threads in this single thread and when on 56k its a bit harsh :( and ive followed all your instructions, twice, and still no luck. i'll have a gander through the thread then. :s

mtha 09-19-2004 03:47 PM

ok, read page 9 and page 11.

Maniaz 09-19-2004 05:54 PM

thnx (k) lol


All times are GMT. The time now is 10:00 AM.

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.02117 seconds
  • Memory Usage 1,947KB
  • 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
  • (8)bbcode_php_printable
  • (37)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