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-30-2010 03:46 AM

Quote:

Originally Posted by Skreech94 (Post 2012618)
I'm getting this error when I click Add page

Database error in vBulletin 4.0.2:

Invalid SQL:
SELECT title, cp_catsid FROM cp_cats ORDER BY title;

MySQL Error : Table 'mydatabase_consoledge.cp_cats' doesn't exist
Error Number : 1146
Request Date : Monday, March 29th 2010 @ 11:10:55 PM
Error Date : Monday, March 29th 2010 @ 11:10:55 PM
Script : http://unlockedgamer.com/admincp/con...php?do=addpage
Referrer : http://unlockedgamer.com/admincp/index.php?do=nav
IP Address : My IP
Username : Username
Classname : vB_Database
MySQL Version : 5.1.30

The problem is that the cp_cats view was not created during the product import and your database user probably do not have privilege for creating that either, the view is needed to retrieve the available categories. Adding and editing a page needs that view to make sure a page has a valid category.
But there are good news, on Saturday April 3rd. I'll release the production version of content pages and the use of that view will not be needed anymore since I changed it to use a pre-populated array of categories instead of the view.

ccampo 04-02-2010 08:35 PM

First official production version was released 1.0.0 and it is now ready to be downloaded.
All reported problems have been fixed.
Enjoy it.

CoZmicShReddeR 04-02-2010 10:26 PM

Just download this got "XML Error: EntityRef: expecting ';' at Line 8" when I tried to install it...

ccampo 04-03-2010 02:29 AM

Quote:

Originally Posted by CoZmicShReddeR (Post 2014864)
Just download this got "XML Error: EntityRef: expecting ';' at Line 8" when I tried to install it...

There was a missing & in the versioncheck line, fixed, download it again.

Leica.Robbiani 04-03-2010 02:58 AM

1 Attachment(s)
Hi,

Quote:

got "XML Error: EntityRef: expecting ';' at Line 8" when I tried to install it...
Just delete the line <versioncheckurl> in the product-xml file or change it to <versioncheckurl />...

But the site is looking a little bit strange in Internet Explorer:

Attachment 115216

The right display of the page should be like this one in Firefox:

Attachment 115217

L.R.

ccampo 04-04-2010 04:54 PM

Quote:

Originally Posted by Leica.Robbiani (Post 2014957)
But the site is looking a little bit strange in Internet Explorer:

Attachment 115216

The right display of the page should be like this one in Firefox:

Attachment 115217

L.R.

I was not able to reproduce your exact problem, however I fixed some MSIE related css style problems which might be able to help you.

I've just uploaded a new 1.0.1 version, unzip and upload all php files again to your host and import the xml file, let me know if that fixes the problem.

KeystoneAirsoft 04-10-2010 06:51 PM

Hi all,

Downloaded both the 1.0.0 and the 1.0.1 versions and tried to install this. I am getting this error message when tryng to add Category:

Quote:

Database error in vBulletin 4.0.2:

Invalid SQL:
SELECT c.cid, c.title, c.icon, c.description, count(p.pid) AS pagecount
FROM contentpages AS p
LEFT JOIN contentpages_categories AS c ON c.cid = p.cid WHERE 1
GROUP BY c.cid, c.title, c.icon;

MySQL Error : Table 'mytable.contentpages' doesn't exist
Error Number : 1146
Request Date : Saturday, April 10th 2010 @ 03:24:11 PM
Error Date : Saturday, April 10th 2010 @ 03:24:12 PM
Script :
Referrer :
IP Address : xxx.xxx.xxx.xxx
Username :
Classname : vB_Database
MySQL Version : 5.0.90-community
After looking in my phpmyadmin I did not find the 2 tables it is supposed to create upon uploading the xml file. The database user has full access to database.


I have tried to uninstall mod and get this error message:

Quote:

Database error in vBulletin 4.0.2:

Invalid SQL:
DROP TABLE `contentpages`;

MySQL Error : Unknown table 'contentpages'
Error Number : 1051
Request Date : Saturday, April 10th 2010 @ 03:50:18 PM
Error Date : Saturday, April 10th 2010 @ 03:50:18 PM
Script : http://mysite/admincp/plugin.php?do=productkill
Referrer : http://mysite/admincp/plugin.php?do=...ontentpages&s=
IP Address : xxx.xxx.xxx.xxx
Username :
Classname : vB_Database
MySQL Version : 5.0.90-community

Any help or suggestion would be appreciated. Thanks in advance.

ccampo 04-11-2010 09:58 PM

There was a problem with the file_exists php function and some file existence verification was failing and was aborting the rest of installation steps.
the xml was fixed and i removed that verification.
I also uploaded a sql script to create those tables manually using phpmyadmin so you can use the MOD.
Just run the SQL script to manually create the tables and use the MOD, or uninstall it and then install it again using the latest zip file.

ccampo 04-11-2010 10:02 PM

1 Attachment(s)
Here's the script.

firefoxextreme 04-11-2010 10:44 PM

Excellent mod thanks, click installed now.


All times are GMT. The time now is 03:30 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.01121 seconds
  • Memory Usage 1,746KB
  • 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
  • (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