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)
-   -   Links and Files Database (https://vborg.vbsupport.ru/showthread.php?t=60403)

AndrewD 12-16-2004 10:06 AM

Quote:

Originally Posted by Spinball
Hi Andrew, hope you are well.
A couple of suggestions I hope might be of interest.
Firstly would it be possible to make rating links optional by forum?
We have a retailers forum and it is open to abuse by competitors leaving low ratings. I would like to disable ratings in this forum.
Secondly I re-submit the idea of being able to add links to a favourites category.
The Favourites category would contain user-specific links and appear in the same way as other categories. It would just contain duplicates of selected favourite links in the other categories.

I'm in the middle of a whole set up improvements, so will see if these can be fitted in. I hadn't forgotten the "favourites" request.

Sovereign 12-16-2004 11:21 PM

*Sovereign clicks install* Just what I needed, but I'm getting this error...(I think it's an error anyway...see pic)

AndrewD 12-17-2004 05:38 AM

Quote:

Originally Posted by Sovereign
*Sovereign clicks install* Just what I needed, but I'm getting this error...(I think it's an error anyway...see pic)

No, that's a standard value - categories/links can be sub-grouped within their parent. By default this does not happen. This setting just controls the default subgrouping.

Tbird66 12-17-2004 11:18 PM

I have a couple of issues with my install:

1. From instructions.txt:

b. Unzip the files somewhere convenient. The templates and natch
subdirectories are for convenience only. You don't need these.

c. Upload local_links.php, local_links_template.xml and get_hotlinks.php
into your *main forum* directory

The only copy I could find of get_hotlinks.php was in the natch subdirectory. The other 2 files were in the root of the unzipped folder. Did I use the correct file?

2. I receive the following error while creating tables:

Database error in vBulletin 3.0.3:

Invalid SQL:
CREATE TABLE IF NOT EXISTS local_linkslink (
linkid int(11) NOT NULL auto_increment,
linkname varchar(255) NOT NULL,
linkdesc text NOT NULL,
linkurl text NOT NULL,
linkhits mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
linkforum smallint(5) NOT NULL,
linkcheck int(10) unsigned NOT NULL,
linkstatus int(10) DEFAULT '0' NOT NULL,
linkdate int(10) NOT NULL,
linkusername text NOT NULL,
linkuserid int(10) NOT NULL,
linkmoderate int(2) NOT NULL,
linkmoddate int(10) DEFAULT '0' NOT NULL,
linkreviewfreq smallint(5) DEFAULT '0' NOT NULL,
PRIMARY KEY (linkid),
FULLTEXT KEY namedesc (linkname,linkdesc)
)

mysql error: The used table type doesn't support FULLTEXT indexes

mysql error number: 1214

I can create the table using Execute SQL Query in AdminCP and putting the qualifier ENGINE = MYISAM; at the end of the CREATE() statement, but then when I re-run local_links_install.php it does not see the table (I can successfully execute a SELECT * FROM local_linkslink query). I've tried skipping the table verification step, but I receive array errors in step 3.

I'm running MySQL 4.1.7 with both MyISAM and InnoDB storage engines enabled. As I'm running on Windows, the InnoDB storage engine is the default instead of MyISAM. InnoDB doesn't support FULLTEXT indexes, thus the need for the qualifier ENGINE = MYISAM;

Any suggestions?

Thanks!

Sovereign 12-18-2004 02:22 AM

No, I meant the part circled in red. The default_cat_dseq. As in what appears to be a mssing variable in the language system (tried searching phrases for that, no luck)

AndrewD 12-18-2004 08:57 AM

Quote:

Originally Posted by Sovereign
No, I meant the part circled in red. The default_cat_dseq. As in what appears to be a mssing variable in the language system (tried searching phrases for that, no luck)

Sorry, one of us is confused ;) default_cat_dseq is the name I have given to one of the settings used by this hack. This variable simply defines the default sub-group that new categories are given within their parent category. There is normally no reason to change this setting.

Am I missing what you are trying to achieve?

AndrewD 12-18-2004 09:02 AM

Quote:

Originally Posted by Tbird66
I have a couple of issues with my install:

1. The only copy I could find of get_hotlinks.php was in the natch subdirectory. The other 2 files were in the root of the unzipped folder. Did I use the correct file?

2. I receive the following error while creating tables:

mysql error: The used table type doesn't support FULLTEXT indexes

You're right - get_hotlinks.php is only used for an integration of this hack with VBindex/VBadvanced developed by Natch. I'd forgotten that the code was a subdirectory deep. I'll update the instructions accordingly.

On the second point, I'll have a look how to adjust the installation script to deal with MySQL 4.1

AndrewD 12-18-2004 11:28 AM

Quote:

Originally Posted by AndrewD
You're right - get_hotlinks.php is only used for an integration of this hack with VBindex/VBadvanced developed by Natch. I'd forgotten that the code was a subdirectory deep. I'll update the instructions accordingly.

On the second point, I'll have a look how to adjust the installation script to deal with MySQL 4.1

It should be sufficient to add one line in the local_links_install.php script. Can you test and let me know? (you'll have to uninstall and reinstall)

Code:

        echo "--- Creating ".THIS_TABLE."linkslink if it does not exist<br />";

        $asb = $DB_site->query("
        CREATE TABLE IF NOT EXISTS ".THIS_TABLE."linkslink (
                linkid int(11) NOT NULL auto_increment,
                linkname varchar(255) NOT NULL,
                linkdesc text NOT NULL,
                linkurl text NOT NULL,
                linkhits mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
                linkforum smallint(5) NOT NULL,
                linkcheck int(10) unsigned NOT NULL,
                linkstatus int(10) DEFAULT '0' NOT NULL,
                linkdate int(10) NOT NULL,
                linkusername text NOT NULL,
                linkuserid int(10) NOT NULL,
                linkmoderate int(2) NOT NULL,
                linkmoddate int(10) DEFAULT '0' NOT NULL,
                linkreviewfreq smallint(5) DEFAULT '0' NOT NULL,
                PRIMARY KEY (linkid),
                FULLTEXT KEY namedesc (linkname,linkdesc)
        )
        TYPE = MYISAM
        ");


Sovereign 12-18-2004 09:10 PM

Quote:

Originally Posted by AndrewD
Sorry, one of us is confused ;) default_cat_dseq is the name I have given to one of the settings used by this hack. This variable simply defines the default sub-group that new categories are given within their parent category. There is normally no reason to change this setting.

Am I missing what you are trying to achieve?

I was wondering whether there was a language string. As in the vB Phrase system...cause I noticed that some of it was not expressed in variables...

Tbird66 12-18-2004 11:57 PM

Quote:

It should be sufficient to add one line in the local_links_install.php script. Can you test and let me know? (you'll have to uninstall and reinstall)
The database install completed successfully, and step 2 Set up templates completed successfully, but now I get the following message:

Step 2 - Template import complete
Run Step 3: Goto Links/Files AdminCP to check/initialise permissions?
Installation complete: Goto Links/Files main page
Delete this script when done
Go back to the start


If I click either Goto link then I get the follwing error:
PHP Warning: array_merge() [function.array-merge]: Argument #2 is not an array in C:\Forum Site\includes\init.php on line 517 PHP Warning: Invalid argument supplied for foreach() in C:\Forum Site\includes\sessions.php on line 270 PHP Warning: array_merge() [function.array-merge]: Argument #2 is not an array in C:\Forum Site\includes\functions.php on line 3615

Any ideas?

Thanks!


All times are GMT. The time now is 03:26 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.02256 seconds
  • Memory Usage 1,758KB
  • 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
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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