vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)
-   -   vB Journal 1.5 Beta 3 (https://vborg.vbsupport.ru/showthread.php?t=100385)

AN-net 01-02-2006 05:24 PM

Quote:

Originally Posted by T3MEDIA
here is a question... how do I delete journals of users that are no longer on the site? say I ban a few members. or they close thier accounts how do I know who is who I see the journals work by first member is journal 1... is there a userid somewhere I can use to bulk remove dead journals?

userids are stored in the DB in the journals table however that probably isnt what you are looking for. a better way may be if you have the profile edit installed you can see if they had a journal. also the search engine by the username is also helpful. in following versions(beta 3 or 4) i may going to include some maintenance tools which should make an admins life easier.

AN-net 01-16-2006 06:32 PM

I just finished the Administration Maintenance Tools and I am wanting suggestions for the Administration Panel for vB Journal. Please post suggestions as soon as possible.

T3MEDIA 01-20-2006 01:38 AM

when this goes pro will old users beable to upgrade? I cant follow the beta testing...

AN-net 01-20-2006 08:01 AM

Quote:

Originally Posted by T3MEDIA
when this goes pro will old users beable to upgrade? I cant follow the beta testing...

yes the upgrade script is like vbulletin's, it sends you to next upgrade script until your up to date.

AN-net 01-20-2006 03:45 PM

just so you know T3 if the Betas dont work the pro wont work either because no one has reported any problems. if you want to tell me what your problems are with it then i can get it working for you. please contact me if you want me to help.

T3MEDIA 01-27-2006 02:15 AM

Well we pm'ed but it seems we lost each other. What is happening is the install wont let me continue. I assume I have old tables? But I have no idea what to remove or keep.

So I am stuck the install does not let me skip or do anything.

I would love some help... just hard to reach you at times and everyone knows 3.5 is the new thing so its hard to get help on the old boards (besides asking you that is)

TruthElixirX 01-30-2006 10:58 PM

I am isntalling this for a client. When I run the install script I get this on step two.

Code:

Database error in vBulletin 3.0.7:

Invalid SQL: CREATE TABLE IF NOT EXISTS journals (
                `journal_id` int(10) NOT NULL auto_increment,
                `journalname` varchar(50) NOT NULL default '',
                `journalist` varchar(50) NOT NULL default '',
                `journalist_id` int(10) NOT NULL default '0',
                `journaldate` int(10) NOT NULL default '0',
                `journaldesc` varchar(90) NOT NULL default '',
                `ipaddress` varchar(15) NOT NULL default '',
                `journalviews` int(10) NOT NULL default '0',
                `entrycount` int(7) NOT NULL default '0',
                `commentcount` int(12) NOT NULL default '0',
                `lastentry` varchar(80) NOT NULL default '',
                `lastentry_date` int(10) NOT NULL default '0',
                `lastentry_id` int(10) NOT NULL default '0',
                `journal_totalrating` int(15) NOT NULL default '0',
                `journal_totalvotes` int(10) NOT NULL default '0',
                `status` tinyint(4) NOT NULL default '0',
                `whovoted` mediumtext NOT NULL,
                `private` tinyint(4) NOT NULL default '0',
                `allowbuddies` tinyint(4) NOT NULL default '0',
                `whocanview` varchar(150) NOT NULL default '',
                `active` tinyint(4) NOT NULL default '0',
                `privatecount` int(10) NOT NULL default '0',
                `lastentry_misc` mediumtext NOT NULL,
                PRIMARY KEY  (`journal_id`),
                UNIQUE KEY `journalist` (`journalist`),
                UNIQUE KEY `journalist_id` (`journalist_id`),
                KEY `lastentry_date` (`lastentry_date`)
                ) ENGINE=MyISAM DEFAULT CHARSET=latin1
       
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 29

mysql error number: 1064

Date: Monday 30th of January 2006 07:51:37 PM
Script: http://themediaforums.com/admincp/journalinstaller.php
Referer: http://themediaforums.com/admincp/journalinstaller.php
Username: tech
IP Address: 162.39.149.138

Please please please tell me you're still giving support.... Thanks a million.

AN-net 01-31-2006 12:01 AM

Quote:

Originally Posted by TruthElixirX
I am isntalling this for a client. When I run the install script I get this on step two.

Code:

Database error in vBulletin 3.0.7:

Invalid SQL: CREATE TABLE IF NOT EXISTS journals (
                `journal_id` int(10) NOT NULL auto_increment,
                `journalname` varchar(50) NOT NULL default '',
                `journalist` varchar(50) NOT NULL default '',
                `journalist_id` int(10) NOT NULL default '0',
                `journaldate` int(10) NOT NULL default '0',
                `journaldesc` varchar(90) NOT NULL default '',
                `ipaddress` varchar(15) NOT NULL default '',
                `journalviews` int(10) NOT NULL default '0',
                `entrycount` int(7) NOT NULL default '0',
                `commentcount` int(12) NOT NULL default '0',
                `lastentry` varchar(80) NOT NULL default '',
                `lastentry_date` int(10) NOT NULL default '0',
                `lastentry_id` int(10) NOT NULL default '0',
                `journal_totalrating` int(15) NOT NULL default '0',
                `journal_totalvotes` int(10) NOT NULL default '0',
                `status` tinyint(4) NOT NULL default '0',
                `whovoted` mediumtext NOT NULL,
                `private` tinyint(4) NOT NULL default '0',
                `allowbuddies` tinyint(4) NOT NULL default '0',
                `whocanview` varchar(150) NOT NULL default '',
                `active` tinyint(4) NOT NULL default '0',
                `privatecount` int(10) NOT NULL default '0',
                `lastentry_misc` mediumtext NOT NULL,
                PRIMARY KEY  (`journal_id`),
                UNIQUE KEY `journalist` (`journalist`),
                UNIQUE KEY `journalist_id` (`journalist_id`),
                KEY `lastentry_date` (`lastentry_date`)
                ) ENGINE=MyISAM DEFAULT CHARSET=latin1
       
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 29

mysql error number: 1064

Date: Monday 30th of January 2006 07:51:37 PM
Script: http://themediaforums.com/admincp/journalinstaller.php
Referer: http://themediaforums.com/admincp/journalinstaller.php
Username: tech
IP Address: 162.39.149.138

Please please please tell me you're still giving support.... Thanks a million.

go into the install file and remove DEFAULT CHARSET= latin1 where ever it exists. this probably solves the dilema.

TruthElixirX 01-31-2006 12:02 AM

Thanks aton!

AN-net 02-03-2006 08:06 PM

beta 3 is coming close to release, so i am still taking suggestions. the focus of this next release is on administration which includes options and the control panel. please submit suggestions quickly!


All times are GMT. The time now is 03:29 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.01206 seconds
  • Memory Usage 1,759KB
  • 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
  • (3)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
  • (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