vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   vBulletin Blog - vBdiary & vBblog - Convert a forum into a diary or weblog (blog) forum. (https://vborg.vbsupport.ru/showthread.php?t=134497)

Calibre_k 12-22-2006 10:40 PM

ADULT SEO... any ideas why I get this........

I get this when I try to add .xml

Database error in vBulletin 3.6.4:

Invalid SQL:
ALTER TABLE `forum` ADD `is_diary` INT( 5 ) NOT NULL DEFAULT '0';;

MySQL Error : Duplicate column name 'is_diary'
Error Number : 1060

Adult SEO 12-22-2006 11:15 PM

Hi!

I don't know as the Install Script should suppress errors.

This is the orignal v1.1 install code:
PHP Code:

$db->hide_errors();
$result $db->query_write("ALTER TABLE `".$vbulletin->config["Database"]["tableprefix"]."forum` ADD `is_diary` INT( 5 ) NOT NULL DEFAULT '0';");
$result $db->query_write("ALTER TABLE `".$vbulletin->config["Database"]["tableprefix"]."thread` CHANGE `password` `diary_password` VARCHAR( 255 ) NOT NULL;");
$result $db->query_write("ALTER TABLE `".$vbulletin->config["Database"]["tableprefix"]."thread` ADD `diary_password` VARCHAR( 255 ) NOT NULL DEFAULT '';");
$result $db->query_write("CREATE TABLE `".$vbulletin->config["Database"]["tableprefix"]."diarythumbnails` (  `threadid` int(20) unsigned NOT NULL DEFAULT '0',  `filedata` mediumblob,  `dateline` int(10) unsigned NOT NULL DEFAULT '0',  `filename` varchar(100) NOT NULL DEFAULT '',  `visible` smallint(6) NOT NULL DEFAULT '1',  `filesize` int(10) unsigned NOT NULL DEFAULT '0',  `width` smallint(5) unsigned NOT NULL DEFAULT '0',  `height` smallint(5) unsigned NOT NULL DEFAULT '0',  PRIMARY KEY (`threadid`));");
$db->show_errors(); 

You can try to do each query manualy from your vBulletin adminpanel -> Maintainance -> Execute SQL Query

You simply copy the code between the query_write("..."); and replace ".$vbulletin->config["Database"]["tableprefix"]." with your table prefix.

Best Regards,
Jan Jaap

Adrian Schneider 12-23-2006 06:59 AM

Just to save you some time, you can use this
PHP Code:

TABLE_PREFIX 

instead of
PHP Code:

$vbulletin->config["Database"]["tableprefix"


basilrath 12-23-2006 02:35 PM

Quote:

Error in the ACP. No announcement. see screenshout
Attached Thumbnails

same here

Adult SEO 12-23-2006 02:46 PM

Quote:

Originally Posted by basilrath (Post 1144011)
same here

Hi!

This is due to missing phrases. This will be fixed with the next update.

Again hours of work have been spent on the original vBulletin datamanager wich is pretty adanced!

I'm almost done with it.

The nice thing of all this work is, that all will perform like vBulletin default.

Best Regards,
Jan Jaap

basilrath 12-23-2006 03:16 PM

sorry to moan !!!!!!!!!!

its a great hack

daft question can we allow members to view the blog or diary etc without them being able to post in reply to the postings within the particular diary or does the password set up mean you can view and post in reply all time.

im confusing myself lol

i mean can you make it so members can view the particular diary / blog entry but not be able to reply to it unless that particular member allowas it.

the password system stops the viewing but allows posting in reply when not passworded.

just wondererd sorry to go on lol merry xmas by the way !

Adult SEO 12-23-2006 04:43 PM

Hi!

Other users then the author even the admin should not be able to reply!

How were you able to reply to a diary of a difrent user?

Best Regards,
Jan Jaap

fishmaster 12-23-2006 04:57 PM

Jan,

When a member has GARS loaded it causes GARS to malfunction causing a database error. I believe it may be do to the template?

Adult SEO 12-23-2006 09:58 PM

Hi!

The Mod has been updated! It now offers an entry page where registered users are able to post comments.

It may look simple, yet it took me 15 hours today to get the comment system setup since it's based on the original vBulletin Postbit factory. The effort is that it will be useable on big high traffic forums and that it's compatible with all servers.

Have Fun!
Jan Jaap

Adult SEO 12-23-2006 09:59 PM

<a href="http://www.grijsje.nl/grijze-roodstaart-dagboeken/8135-dagboek-isis.html" target="_blank">http://www.grijsje.nl/grijze-roodsta...boek-isis.html</a>


All times are GMT. The time now is 10:36 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.01077 seconds
  • Memory Usage 1,749KB
  • 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
  • (3)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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