Codezwiz >> Forums >> General PHP Nuke Help >> NuCalendar Warning error Help

Hi all,

I have an error on my NuCalendar (Modules)

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ghost/public_html/includes/sql_layer.php on line 342

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ghost/public_html/includes/sql_layer.php on line 342

Register

I don't think there is an error in your (edit remove: includes.php) sql_layer.php since that file isn't modified with the install of NuCalendar. I would suggest trying to re-install your module from scratch and see if that makes any difference.

Sorry I couldn't be of any more help on that one. I got lucky and it worked on the first try.

Ok . Done.." Same Error"

Register

Add this line after line 342 (the line with the error) in the sql_layer.php:

echo mysql_error();

ok this is what i get

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ghost/public_html/includes/sql_layer.php on line 342
Table 'ghost_.nuke_nucal_options' doesn't exist
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ghost/public_html/includes/sql_layer.php on line 342
Table 'ghost_.nuke_nucal_options' doesn't exist

it says that u are missing a table in the db. Table 'ghost_.nuke_nucal_options' doesn't exist. check to see if it's named wrong or add the table.

ok its not there. In the Docs it didn't say anything about adding an db.... ok how do i do that?

Is there a file that u have to run to install it or does it come with a sql folder or file?

Sorry. I don't know nething about the calander. But I will dl it to c if i can help u. where did u get it?

I c Dauth was helpin ya. I just responded to this thread cause i noticed that u were online and may have been waiting 4 an answer, while he was offline.

Register

In case you haven't figured this out. The following text comes from the Readme file of the module.

1. Introduction
NuCalendar is a PHP-Nuke add-on which allows the administrator to manage
event schedule information. Events can be either a one time event, or
reoccur at regular intervals.

2. Install & Upgrade (from v0.10)
Use the file nucalendar.sql, located in the sql directory, to create the
initial tables. Change the name of the tables to match your $user_prefix.

Copy the files from the admin, block, images, and modules directories to
their corresponding location on your site.

Merge the merge.lang-yourlang.php file, located in admin/language with your
admin/language/lang-yourlang.php file.

If you want to add a line in your Waiting Content block that tells you the
number of events waiting for admin approval, merge the files
mainfile.php.hack.youverionofnuke into your mainfile.php in function
adminblock() (approx line 673 for version 6.5) and merge
language/lang-yourlang.php.hack with your language/lang-yourlang.php file.

2a. Upgrade users (after following above steps): The NuCalendar admin block
will contain a link to import your events from the old format to the new.
The script is pretty good at importing the data, but it is not 100%. Typically
events with single quotes in them do not import properly. Using phpMyAdmin
(or similar) to manually import events the script does not. Once you are happy
that all of your data is imported you may drop tables nuke_nucal_bydate and
nuke_nucal_recurring and the import link will go away.

2b. Near the top of admin/modules/nucalendar.php is a
require_once("modules/NuCalendar/dbaccess.inc.php"); and
require_once("modules/NuCalendar/printevent.php"); Make sure that the paths
are correct for your install.

3. Upgrade (from v0.51)
Import the sql files from the version you are upgrading from to the version
you are installing. You may need to import multiple sql files depending on
your install. IE v050_v051.sql.

4. Use
Use the NuCalendar icon, located in the admin panel, to manage events.

Note the first part:

Use the file nucalendar.sql, located in the sql directory, to create the
initial tables.

Check the download file and see if their isn't some sort of sql file there. If there is, you will need to dump the sql into your database using PHPmyAdmin. You should have some experience with this, or have your web host assist you. You will need your username and password for PHPmyAdmin before you can get into it.

Dont forget to remove the:

echo mysql_error();

Well That Did IT!!! It Worked... Thank YOU Two Very MUCH

The nucalendar.sql had to be added to the phpmyadmin.. db sql area.