vb.org Archive
Page 9 of 34 « First 78 9 101119 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   vB.Sponsors - Forum and Category Sponsorship with Statistics (https://vborg.vbsupport.ru/showthread.php?t=103327)

kompakt 01-11-2006 04:09 AM
While in the middle of installing and editing the 1.02 version I got the email for the new one 1.03. So I installed that version. The main problem now seems to be that its not saving the settings for vB.Sponsors. For further testing, I went and edited the forumhome templates to assume the sponsors are always enabled and it worked fine.

Also, for lawahdy .. Mannak lawahdak, I got the same error when checking statistics :)

kompakt 01-11-2006 04:36 AM
Ok, Now I got a new error trying to reinstall it. Any tips how to completely uninstall it with parts from the installation file?

Code:
Database error in vBulletin 3.5.2:

Invalid SQL:

                                INSERT INTO productcode
                                        (productid, version, installcode, uninstallcode)
                                VALUES
                                        ('vB.Sponsors',
                                        '1.0.0',
                                        '\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum ADD (sponsor_enabled INT(6) UNSIGNED NOT NULL DEFAULT \'0\')\");\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum ADD (sponsor_banner_enabled INT(6) UNSIGNED NOT NULL DEFAULT \'0\')\");\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum ADD (sponsor_name VARCHAR(250) NOT NULL DEFAULT \'\')\");\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum ADD (sponsor_banner VARCHAR(250) NOT NULL DEFAULT \'\')\");\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum ADD (sponsor_url VARCHAR(250) NOT NULL DEFAULT \'\')\");\r\n$db->query_write(\"CREATE TABLE \" . TABLE_PREFIX . \"vBSponsors (id INT NOT NULL, sponsor_name VARCHAR(255) NOT NULL, forum TEXT NOT NULL, date TEXT NOT NULL, PRIMARY KEY (id)) TYPE=MyISAM\");\r\n                        ',
                                        '\r\n$db->hide_errors();\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum DROP sponsor_enabled\");\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum DROP sponsor_banner_enabled\");\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum DROP sponsor_name\");\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum DROP sponsor_banner\");\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum DROP sponsor_url\");\r\n$db->query_write(\"DROP TABLE \" . TABLE_PREFIX . \"vBSponsors\");\r\n$db->show_errors();\r\n                        ');

MySQL Error  : Duplicate entry '16' for key 1
Error Number : 1062

kommuni 01-11-2006 08:09 AM
hey,

just to be completed: the import of the xml is working now, but there's still no sponsor shown in the index.php next to the forums.

also i see the sql error when having a look at the stats. there doesn't seem to be a table "vbSponsors".

lawahdy 01-11-2006 11:19 AM
Quote:
Originally Posted by kommuni
hey,

just to be completed: the import of the xml is working now, but there's still no sponsor shown in the index.php next to the forums.

also i see the sql error when having a look at the stats. there doesn't seem to be a table "vbSponsors".

i'm having the same problem.

trying to work around it.. oncei manage to do so i will let you guys know..

Deviation 01-11-2006 11:33 AM
I'll check this out when I get home tonight. Please be sure to post your PHP & MySQL versions with your errors (just edit the posts you made). I've been developing this on MySQL 5.0.17 and PHP 5.1.1, so there's bound to be some differences.

The common issue is the missing table. Since this is a fresh install for most of you, please uninstall the product. Then try reinstalling. Let me know what the results are.

lawahdy 01-11-2006 11:41 AM
Quote:
Originally Posted by Deviation
I'll check this out when I get home tonight. Please be sure to post your PHP & MySQL versions with your errors (just edit the posts you made). I've been developing this on MySQL 5.0.17 and PHP 5.1.1, so there's bound to be some differences.

The common issue is the missing table. Since this is a fresh install for most of you, please uninstall the product. Then try reinstalling. Let me know what the results are.
i did a reinstall, uninstall - reinstall, complete remove of even template changes and files and reinstall... nothing.. same problems..

PHP Version 4.4.1
mySQL 4.1.11

lifesourcerec 01-11-2006 05:52 PM
Only if I can get the templates to add. Modifying them and when I click save.. it just sits there. I see the bar moving at the bottom as it is trying to save, but it never goes to the next screen.

It happens when I add it to the "forumhome_forumbit_level1_post" template. But when I remove that part of the code, it saves fine.

Deviation 01-11-2006 11:21 PM
A new version has been released. 1.0.4. Please upgrade.

lifesourcerc, your template errors have been corrected. The included template code has been updated.

Thanks for the patience. I rushed the 1.0.2 release thinking that this might happen. Hopefully this is the end of the bugs for now. :nervous:

lawahdy 01-11-2006 11:38 PM
Quote:
Originally Posted by Deviation
A new version has been released. 1.0.4. Please upgrade.

lifesourcerc, your template errors have been corrected. The included template code has been updated.

Thanks for the patience. I rushed the 1.0.2 release thinking that this might happen. Hopefully this is the end of the bugs for now. :nervous:

okay .. cool work.. bless.. it is showing now in the forum.. yepppy.. but when you click on the "Forum Sponsored By: XXXX" as text it give me this error..

Code:
Database error in vBulletin 3.5.2:

Invalid SQL:
INSERT INTO `vBSponsors` ( `id` , `sponsor_name` , `forum_id`, `forum`, `date` ) VALUES ( '', 'La7oon', '14', 'Arabic', '1137029793');

MySQL Error  : Unknown column 'forum_id' in 'field list'
Error Number : 1054
Date        : Wednesday, January 11th 2006 @ 05:36:33 PM
Script      : http://www.dubaidjs.com/forums/vB.Sponsors/link.php?f=14
Referrer    : http://www.dubaidjs.com/forums/index.php
IP Address  : xxxxxxxxxx
Username    : lawahdy
Classname    : vb_database
and in the statistics it gives me this error.
Code:
Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT COUNT(*) AS hits, FROM_UNIXTIME(date, '%m-%d-%Y') AS fdate FROM vBSponsors WHERE forum_id = '14' GROUP BY fdate;

MySQL Error  : Unknown column 'forum_id' in 'where clause'
Error Number : 1054
Date        : Wednesday, January 11th 2006 @ 05:34:59 PM
Script      : http://www.dubaidjs.com/forums/admincp/vBSponsors.php
Referrer    : http://www.dubaidjs.com/forums/admincp/vBSponsors.php?do=statistics
IP Address  : xxxxxxxxxxxxxxxxxxx
Username    : lawahdy
Classname    : vb_database
i'm i not lucky or what..?

Devil Woman 01-12-2006 07:11 AM
I have installed this and added a banner, the picture of the banner doesn't even show up and when I click on where the picture is supposed to be I get this

Quote:
Warning: main(/global.php): failed to open stream: No such file or directory in /home/content/d/a/r/darksidemedia/html/board/vB.Sponsors/link.php on line 29

Fatal error: main(): Failed opening required '/global.php' (include_path='.:/usr/local/lib/php') in /home/content/d/a/r/darksidemedia/html/board/vB.Sponsors/link.php on line 29
Am i doing anything wrong?

Thanks


All times are GMT. The time now is 11:26 AM.
Page 9 of 34 « First 78 9 101119 Last »
Show 40 post(s) from this thread on one page

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.01519 seconds
  • Memory Usage 1,756KB
  • 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_code_printable
  • (4)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