vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   vBJournal Lite 1.1b (https://vborg.vbsupport.ru/showthread.php?t=43717)

redd 12-24-2002 02:00 PM

We've been using this hack for a few months without any problems. Now, all of a sudden, we've been receiving error messages:

Database error in vBulletin :

Link-ID == false, connect failed
mysql error:

mysql error number:

Date: Tuesday 24th of December 2002 09:40:46 AM
Script: /forum/journal.php?s=&journalid=12338&action=view

We ONLY receive errors regarding connecting to view the journals, not the rest of the forum, and we've received at least 30 in the last week.

Has anyone else been having problems?

EcpHosting 12-29-2002 09:59 PM

NOTE: please during setup of the new version, allow the user to SELECT which STYLE to install to. The installation installed to my default style and didnt go to my CUSTOM style.

Just a note, and i may have missed something, but if you are getting a blank screen AND are using a custom style, you will need to move templates over from default to your style.

EcpHosting 12-29-2002 10:57 PM

I am getting the following error when users attempt to create a journal entry:

Quote:

Database error in vBulletin 2.2.9:

Invalid SQL: UPDATE user SET journal=1 WHERE userid=1
mysql error: Unknown column 'journal' in 'field list'

mysql error number: 1054

Date: Sunday 29th of December 2002 07:14:32 PM
Script: http://bigfish.truewalk.com/journal....=createjournal
Referer:
However, if the user REFRESHES the page, it says the journal already exists and it acts flawless from there.

Also, the "$forums" in the postbit is not working for the user who has an entry. Any ideas for either?

Brahm 01-01-2003 04:49 AM

Yeah when I try to install in 2.29 I get to step 3 and get a MySQL error,

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: CREATE TABLE journal (
journalid int(11) NOT NULL auto_increment,
title text NOT NULL,
description text NOT NULL,
imagename text NOT NULL,
entries int(11) NOT NULL default '0',
views int(11) NOT NULL default '0',
enabled smallint(6) default '0',
timestamp int(11) NOT NULL default '0',
userid int(11) NOT NULL default '0',
PRIMARY KEY(journalid)) TYPE=MyISAM;
mysql error: Table 'journal' already exists

mysql error number: 1050

Date: Wednesday 01st of January 2003 12:10:56 AM
Script: http://www.ashkins.net/forum/forum/a...nal.php?step=3
Referer: http://www.ashkins.net/forum/admin/i...nal.php?step=2

Brahm 01-01-2003 07:59 AM

Man oh man. With a little manual database entry I managed to push past the above error message. I created the tables and did the inserts manually through the end of the install, and it now works. Thanks a bunch Ryangel. It works, it really works!

Elvis 01-12-2003 07:13 AM

Quote:

Originally posted by Willard Reece
But basicly my only prob with it is I wish a admin could delete post made in any journal or what ever.
I didn't see that as a option. and also the error page.


I've done it.... it was annoying the crap outta me too....

this file will:

display 20 of each of the 3 columns on the Journal jump page, and will also allow admins to edit/delete journal entries and comments.

Just download and rename this file to journal.php
then upload to your main directory

Enjoy,

Elvis

indiamike 01-12-2003 02:21 PM

Quote:

Originally posted by Elvis

I've done it.... it was annoying the crap outta me too....

Elvis

Uploaded and just got errors.... :confused:
Quote:

Database error in vBulletin 2.2.5:

Invalid SQL: SELECT u.username, e.entryid, e.journalid, e.title, e.entry, e.timestamp, e.userid, e.private, e.displayorder, e.comments
FROM journal_entry e
LEFT JOIN user u ON e.userid = u.userid
WHERE e.journalid = 81
ORDER BY e.timestamp DESC LIMIT
mysql error: You have an error in your SQL syntax near '' at line 5

mysql error number: 1064

Date: Sunday 12th of January 2003 11:12:23 AM
Script: http://www.indiamike.com/india/india...81&action=view
Referer: http://www.indiamike.com/india/journal.php
Seems to be requesting the wrong url.

Elvis 01-12-2003 03:23 PM

Quote:

Originally posted by indiamike


Uploaded and just got errors.... :confused:

Seems to be requesting the wrong url.



Well, I just verified that the file I uploaded is exactly like the one I currently have in use - it is.

Also... from the error, it looks as though you may be missing a line of an SQL statement - did you edit this file AT ALL?

and finally, I dont understand how you could be requesting a wrong URL, every instance of the goto starts like:

$goto="journal.php?s=

it's referring to itself - there are no directory changes at all.

indiamike 01-12-2003 06:03 PM

hmmm...I didn't alter it it in anyway and just uploaded it to try it out to see what it would do.

I uninstalled it but the error showed up when I would click on a members name to view their journal.

Has anyone else tried this yet?

Mike

sabret00the 01-19-2003 01:35 PM

i got multiple stylesets but your installer will only install to the default is their a fix available?


All times are GMT. The time now is 09:47 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.01353 seconds
  • Memory Usage 1,745KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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