vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - News Management & Portal System Lite (https://vborg.vbsupport.ru/showthread.php?t=172867)

fragumz.com 04-15-2008 12:00 AM

Quote:

Originally Posted by joeycano (Post 1463501)
Also got error:

Invalid SQL:
CREATE TABLE `vb_nmaps_settings` (
`varname` varchar(100) NOT NULL,
`set_value` varchar(25) NOT NULL,
PRIMARY KEY (`varname`)
) ENGINE=MyISAM DEFAULT;

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 '' at line 5
Error Number : 1064

:(

Also, I tried installing the fix above


Try this:


PHP Code:

CREATE TABLE `vb_nmaps_settings` (
`
varnamevarchar(100NOT NULL,
`
set_valuevarchar(25NOT NULL,
PRIMARY KEY (`varname`)
); 

This should fix the sql problem. If not, PM me and I will recheck.:D

Mythotical 04-15-2008 12:49 AM

Oops, forgot about ENGINE=MyISAM DEFAULT, I try to get rid of it before releasing code. My bad. Thanks fragumz.com

dcw 04-16-2008 06:31 AM

So how do I add an artical? I have it installed but I can't post nothing in it...

Mythotical 04-16-2008 05:07 PM

You have to set yourself as a reporter through the user section of your admincp.

trigon 04-16-2008 06:02 PM

In the nmaps Setting we can change if the Chief Avatar is shown or not.
But where is the avatar? Cause my isnt shown there.
Quote:

Image preferences->
Display the cheif's avatar?
Yes No

dcw 04-16-2008 06:17 PM

Oh thanks, that would help right lol...

What is the links in the navigation do? Can we use them for what we want? if so how do we change them?

Mythotical 04-16-2008 09:14 PM

dcw: The navigation links are controlled via a template.

trigon: You must make sure the avatar is actually selected from your gallery and not a custom uploaded avatar, that feature is not working fully, only gallery avatars will work.

gbcompro 04-19-2008 10:45 AM

which folder on your sever do you upload the files ?

trigon 04-19-2008 12:12 PM

Quote:

Originally Posted by Steve M (Post 1492493)
dcw: The navigation links are controlled via a template.

trigon: You must make sure the avatar is actually selected from your gallery and not a custom uploaded avatar, that feature is not working fully, only gallery avatars will work.

Ok, works. Another Quest: How can i modifiy/delete News?

Mythotical 04-19-2008 11:17 PM

gbcompro: What files? NMAPS files goes to your root directory, avatars are housed however your options are setup via admincp.

Trigon: As a reporter you have a specific section you can manage news or you can manage it through the admincp.

trigon 04-24-2008 03:31 AM

Sort it out, it works well, but after update to rc4 it shows me only a blank white page. Any solution?

Mythotical 04-24-2008 03:08 PM

Yeah I'm trying to avoid doing update after update, I'm waiting for 3.7 gold to be released then I'm gonna update NMAPS to be rid of blank white pages.

trigon 04-30-2008 03:53 PM

Any News?

Mythotical 04-30-2008 05:57 PM

Since 3.7 just got released, we are checking to make sure current version works with it before we move on to adding Pro features.

trigon 04-30-2008 06:53 PM

yep, cant wait until this "bug" is solved. :)

Mythotical 05-01-2008 01:10 AM

Which bug?

EDIT: NVM, blank white screen, I remember.

AidoStyles 05-01-2008 03:41 PM

How come BBCode doesn't work? And if you press "enter" when typing a paragraph, it doesn't create a space.

Nindia 05-01-2008 05:58 PM

How much work would be involved to make this work in a different directory?

ie.

Currently it's being run out of "/forums"

I would like to implement it into my root directory but keep the forums in the "/forums" directory. Is this possible easily? Or is it a whole whack of work?

Thanks in advance!

and great work on the script!

Mythotical 05-25-2008 04:04 PM

Aido: Not sure why BBCode's not working, I will check on both those this evening.

Nindia: Not sure, never tested it from another directory. If anything you would just have to update the links and alter the location of the global.php file which I will probably turn into a setting so that it can be housed in another directory. Just an FYI, not alot of work, just a new setting and such, I will get that done this evening.

trigon 05-25-2008 04:24 PM

Quote:

Originally Posted by Steve M (Post 1466748)
I have just did the uninstall file. Please use this if you have installed v2.0 Lite. I have also added these same instructions and zip file to original post.

UNINSTALLATION INSTRUCTIONS:
These instructions are for those who installed v2.0 Lite, when we bring NMAPS back it will be 2.1.

1. Extract contents of NMAPS v2.0 Uninstall.zip to your local harddrive
2. Upload contents to appropriate folders
3. Browse to http://www.yourdomain.com/admincp/nmaps_uninstall.php
4. Follow instructions
5. Done you have removed all aspects of NMAPS v2.0 Lite

after uninstalling i got this error:
Quote:

Datenbankfehler in vBulletin 3.7.0:

Invalid SQL:
ALTER TABLE IF EXISTS `usergroup` DROP `nmaps_perms`;

MySQL-Fehler : 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 'IF EXISTS `usergroup` DROP `nmaps_perms`' at line 1
Fehler-Nr. : 1064
Fehler-Zeit : Sunday, 25.05.2008 @ 19:20:40
Datum : Sunday, 25.05.2008 @ 19:20:40
Skript : http://www.xxxxxxxxxxxxx.com/admincp...all.php?step=2
Referrer : http://www.xxxxxxxxxxxxx.com/admincp...all.php?step=1
IP-Adresse : xx.xx.xxx.xxx
Benutzername : trigon
Klassenname : vB_Database_MySQLi
MySQL-Version : 4.1.13

macc 05-25-2008 04:59 PM

Hello!

me too ..get same error when try uninstall ...
Code:

Database error in vBulletin 3.7.0:Invalid SQL:ALTER TABLE IF EXISTS `vb_usergroup` DROP `nmaps_perms`;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 'IF EXISTS `vb_usergroup` DROP `nmaps_perms`' at line 1Error Number  : 1064Request Date  : Sunday, May 25th 2008 @ 01:33:33 PMError Date    : Sunday, May 25th 2008 @ 01:33:33 PMScript        : http://www.belaplay.com/vb/libar/adm...all.php?step=2Referrer      : http://www.belaplay.com/vb/libar/adm...all.php?step=1IP Address    : xx.xxx.xxx.xxxUsername      : AdminClassname    : vB_DatabaseMySQL Version : 4.1.22-standard
after i get another error when i try navigate npms.php page
Code:

Fatal error: Can't use method return value in write context in /home2/belapla/public_html/vb/libar/nmaps.php on line 405
this error comes up when i upload new files and import new product.xml file


some help?

regards

macc

macc 05-25-2008 06:00 PM

Have unistalled completly and install again and now get only this error when try to come on nmaps.php

"Fatal error: Can't use method return value in write context in /home2/belapla/public_html/vb/libar/nmaps.php on line 405"

reg

macc

Mythotical 05-26-2008 04:08 AM

Oops, forgot to remove that uninstall file, right now the uninstall file does not work with 3.7

LisaJH 05-26-2008 05:19 AM

So i take it t his install dont work? i am about to install it but dont want to just yet...

trigon 05-26-2008 03:50 PM

i try to do a new install, but now i got this error:
Quote:

Datenbankfehler in vBulletin 3.7.0:

Invalid SQL:
ALTER TABLE `usergroup`
ADD `nmaps_perms` INT( 10 ) UNSIGNED NOT NULL;

MySQL-Fehler : Duplicate column name 'nmaps_perms'
Fehler-Nr. : 1060
Fehler-Zeit : Monday, 26.05.2008 @ 18:49:06
Datum : Monday, 26.05.2008 @ 18:49:06
Skript : http://www.xxxxxxxxxx.com/admincp/nm...all.php?step=2
Referrer : http://www.xxxxxxxxxx.com/admincp/nm...all.php?step=1
IP-Adresse : xx.xx.xxx.xxx
Benutzername : trigon
Klassenname : vB_Database_MySQLi
MySQL-Version : 4.1.13

macc 05-26-2008 05:29 PM

yes ...uninstalled ...

reg

macc

sbarbz 05-26-2008 05:46 PM

Database error in install for vBulletin 3.7.0:
Quote:

Database error in vBulletin 3.7.0:

Invalid SQL:
CREATE TABLE `nmaps_cats` (
`cat_id` int(5) NOT NULL auto_increment,
`cat_name` varchar(100) NOT NULL,
`cat_desc` mediumtext NOT NULL,
`cat_image` varchar(100) NOT NULL default '',
`cat_dis` varchar(5) NOT NULL,
PRIMARY KEY (`cat_id`)
);

MySQL Error : Table 'nmaps_cats' already exists
Error Number : 1050
Request Date : Monday, May 26th 2008 @ 09:41:27 PM
Error Date : Monday, May 26th 2008 @ 09:41:27 PM
Script : http://zcomp.co.il/admincp/nmaps_install.php?step=2
Referrer : http://zcomp.co.il/admincp/nmaps_install.php?step=1
IP Address : my ip
Username : Lom
Classname : vb_database
MySQL Version : 4.1.21-standard
How to repair?

Mythotical 05-26-2008 06:06 PM

sbarbz: You need to remove all instances of nmaps_ from your database, that just means it already exists.

Mythotical 05-26-2008 06:08 PM

Lisa: The fresh install portion works, their errors are from existing installs, since 3.7 Gold is released I'm gonna do work tonight to have it updated and working flawlessly on 3.7 as well as the uninstall script.

Trigon: Try to do an overwrite, not a fresh install.

sbarbz 05-26-2008 06:14 PM

Quote:

Originally Posted by Steve M (Post 1532093)
sbarbz: You need to remove all instances of nmaps_ from your database, that just means it already exists.

How I execute this ? :D

Mythotical 05-26-2008 06:21 PM

I will get the uninstall script done as soon as I update my test forum to 3.7 gold so probably a few hours from now you will be able to use my uninstall script to get rid of it.

sbarbz 05-26-2008 06:38 PM

Where I find the script ?

Mythotical 05-26-2008 07:58 PM

sbarbz: I am updating it, I will have it ready in about an hour.

therock67 05-26-2008 08:45 PM

Steve,

Just installed the mod. Getting the following error

Quote:

Parse error: syntax error, unexpected '(', expecting ',' or ')' in /home/thefreek/public_html/vbforum/nmaps.php on line 405
Any ideas?

Mythotical 05-26-2008 09:27 PM

Not yet, once I have the uninstall script working again, I will be looking into the NMAPS errors.

ExTincTi0N 05-26-2008 10:02 PM

I get this

Database error in vBulletin 3.7.0:

Invalid SQL:
CREATE TABLE `nmaps_cats` (
`cat_id` int(5) NOT NULL auto_increment,
`cat_name` varchar(100) NOT NULL,
`cat_desc` mediumtext NOT NULL,
`cat_image` varchar(100) NOT NULL default '',
`cat_dis` varchar(5) NOT NULL,
PRIMARY KEY (`cat_id`)
);

MySQL Error : Table 'nmaps_cats' already exists
Error Number : 1050
Request Date : Monday, May 26th 2008 @ 06:01:42 PM
Error Date : Monday, May 26th 2008 @ 06:01:42 PM
Script : http://line-artists.com/admincp/nmap...all.php?step=2
Referrer : http://line-artists.com/admincp/nmap...all.php?step=1
IP Address : 71.53.92.129
Username : .RevO
Classname : vB_Database
MySQL Version : 5.0.45-community

After clicking to go onto step 2

shofolofo 05-26-2008 10:28 PM

would've been an awesome script .. but iam scared from the comments

:(

Mythotical 05-26-2008 10:37 PM

Shofolofo: your not reading the comments very well then, they are errors regarding the tables already existing, if you have never installed the script, it will go fine as long as its a fresh install.

Extinction: Please scroll up and read my comment regarding duplicate entry errors. I am currently working on a way to bypass those errors when upgrading or uninstalling.

ExTincTi0N 05-26-2008 10:42 PM

Ok if it already exists when I try to go to it I get this.

Fatal error: Can't use method return value in write context in /home/emind/public_html/line-artists/nmaps.php on line 405

Mythotical 05-26-2008 11:06 PM

Extinction: That error I'm not sure of, I will check on it once I am done with the uninstall/install script.

EDIT: Correction, I know the error now, I will have a fix for it soon, that was my bad.


All times are GMT. The time now is 06:22 PM.

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.01727 seconds
  • Memory Usage 1,830KB
  • 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
  • (1)bbcode_php_printable
  • (9)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
  • (40)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