vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - Content Pages for vB 4.0 (https://vborg.vbsupport.ru/showthread.php?t=239235)

ccampo 03-28-2010 01:33 AM

Quote:

Originally Posted by Junkie (Post 2011365)
Where exactly do I add - GRANT CREATE VIEW ON *.* TO 'database_username'@'localhost'? Is this something I have to do in phpMyAdmin? I have all of the database privileges (select, insert, update, delete, index, create temporary tables, create, alter, drop, lock tables, references and create routine) set to on

See my reply above, here's again :
You will need to be logged on as root or the main database user to do this.

or talk to your host provider, they should be able to help you.

ccampo 03-28-2010 01:36 AM

Quote:

Originally Posted by rammieone (Post 2011333)
Would this install fine on 4.0 as well?

I've tested this on 4.0.1, 4.0.2, 4.0.2 PL4 and it works in all of them, it should also work on the very base 4.0 version that was released.

NFLfbJunkie 03-28-2010 01:43 AM

How did you fix the page width problem?

NFLfbJunkie 03-28-2010 01:58 AM

I noticed from your demo site that the content pages stretch the original width of the forum pages. Can this be fixed?

ProFifaLeagues 03-28-2010 06:34 AM

Quote:

Originally Posted by ccampo (Post 2011357)
I've tested this on 4.0.1, 4.0.2, 4.0.2 PL4 and it works in all of them, it should also work on the very base 4.0 version that was released.


Many thanks

ccampo 03-28-2010 11:24 AM

Quote:

Originally Posted by Junkie (Post 2011389)
How did you fix the page width problem?

Fix was uploaded, you can download it again, it was a problem with the template.

NFLfbJunkie 03-28-2010 03:16 PM

Since I can not get your MOD to work, and wish I could, I installed another pages MOD. But this one has the same problem that yours initially did - the pages stretching across the entire page. I posted this in the MOD's thread, but still haven't gotten a response. Can you tell me what the fix was for your MOD so I can see if it possibly might apply to this one. Thanks.

mandingo 03-28-2010 08:36 PM

uhhh. So after getting the root database privileges changed I get this error now instead.
Quote:

Database error in vBulletin 4.0.2:

Invalid SQL:
CREATE VIEW `cp_cats` (cp_catsid, title) AS
SELECT `cid`, `title` FROM `vb_contentpages_categories`;

MySQL Error : Table '*****.vb_contentpages_categories' doesn't exist
Error Number : 1146
Request Date : Sunday, March 28th 2010 @ 04:31:24 PM
Error Date : Sunday, March 28th 2010 @ 04:31:25 PM
Script : http://mysite/admincp/plugin.php?do=productimport
Referrer : http://mysite/admincp/plugin.php?do=productadd
IP Address : 75.172.232.60
Username : yez
Classname : vB_Database
MySQL Version : 5.1.30

ccampo 03-28-2010 10:07 PM

I've found a big security hole when displaying php content pages so I've removed that feature from this mod, displaying php code also affects the look and feel of the vBulletin's style of the site and forum so for now, no php support, I've uploaded a new beta version 0.8.0 so please download and use that one instead.

ccampo 03-28-2010 10:14 PM

Quote:

Originally Posted by mandingo (Post 2011862)
uhhh. So after getting the root database privileges changed I get this error now instead.

That's weird, that error would only happen if the xml file was modified in some way to execute the SQL commands in some other order, the error means that the needed table to create the view doesn't exist, and that cannot be possible because that table is created right before creating the view, unless that create table also failed?.

I'd suggest you to deinstall "Content Pages" products, then use phpMyAdmin to make sure tables vb_contentpages and vb_contentpages_categories do not exist, otherwise drop them and then import the new 0.8.0 xml file again.

good luck.


All times are GMT. The time now is 02:07 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.01062 seconds
  • Memory Usage 1,740KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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