[jamesd116]

What files take part in adding the schema file to the db I have 3 tables and none of the tables are being added in this last module I am trying to build I have checked over the schema.php file over a hundred times over the last 2 or 3 weeks and it looks to be right. I compared it to other schema files and everything matches up including all of the symbols. I did notice to add the extra tables to the include.php "Define Custom Tables" area. Are there any other files that have to do with adding the tables upon running the integrity check. When I run it my module shows up at the bottom but when I check the db the tables are not added.


_________________
One day the court system will learn that a childs mother is not the only option...... Question is will it be too late by that time...

[Brian]

jamesd116:

What files take part in adding the schema file to the db I have 3 tables and none of the tables are being added in this last module I am trying to build I have checked over the schema.php file over a hundred times over the last 2 or 3 weeks and it looks to be right. I compared it to other schema files and everything matches up including all of the symbols. I did notice to add the extra tables to the include.php "Define Custom Tables" area. Are there any other files that have to do with adding the tables upon running the integrity check. When I run it my module shows up at the bottom but when I check the db the tables are not added.

Make sure you have defined the table names in your module's include.php file.

Hope this helps!

- Brian


_________________
Make sure and check out:
* The Jamroom FAQ
* The Jamroom Documentation

[jamesd116]

this has been done but it does not work

Code

// Define custom database tables $jamroom_db['rt_library'] = $config['db_prefix'].'rt_library'; $jamroom_db['rt_carriers'] = $config['db_prefix'].'rt_carriers'; $jamroom_db['rt_userips'] = $config['db_prefix'].'rt_userips';

_________________
One day the court system will learn that a childs mother is not the only option...... Question is will it be too late by that time...

[smith.kyle]

Put:

fdebug($jamroom_db);

in your schema.php file, and then run an integrity check and look in your logs/ directory for jr_debug_log and check to see if the table names show up there. (Then remove fdebug)


_________________
kyle[at]jamroom.net

Yes...that's a soda machine...

I get bored when no one's posting...

[jamesd116]

nope nothing showed eup in the logs file


_________________
One day the court system will learn that a childs mother is not the only option...... Question is will it be too late by that time...

[smith.kyle]

And you have an include.php file in your module's directory? That's the file that Jamroom needs to see that it is a module.


_________________
kyle[at]jamroom.net

Yes...that's a soda machine...

I get bored when no one's posting...

[jamesd116]

smith.kyle:

And you have an include.php file in your module's directory? That's the file that Jamroom needs to see that it is a module.

Yes I have the include.php file and it defines the tables within it I have went over the include file over and over and over again making sure that everything was cottect in it.


_________________
One day the court system will learn that a childs mother is not the only option...... Question is will it be too late by that time...

[smith.kyle]

Do you have any php errors? If they are in the module's include.php file then it should be working.


_________________
kyle[at]jamroom.net

Yes...that's a soda machine...

I get bored when no one's posting...

[jamesd116]

no errors in the php error log and the activity log itself is not working for me


_________________
One day the court system will learn that a childs mother is not the only option...... Question is will it be too late by that time...

[SteveX]

I don't think you get any errors if the sql doesn't run properly, that would be the first place I'd check.


_________________
Kulshi Mezian!

"Stranger from another planet, welcome to our hole. Just strap on your guitar and we'll play some rock and roll"

Ultrabubble create things.

[Brian]

SteveX:

I don't think you get any errors if the sql doesn't run properly, that would be the first place I'd check.

If errors are encountered in the SQL when trying to write to the log table, then it is logged to the jamroom/logs/jr_debug_log

Hope this helps!

- Brian


_________________
Make sure and check out:
* The Jamroom FAQ
* The Jamroom Documentation

[dagilli]

make sure to have:

dbVerifyTable($jamroom_db['rt_********'],$tbl);

at the end of all the CREATE TABLE statements in the schema.php

Of course the ****** is your new table names....


_________________
"With No Music, There Could Be No Harvest"
* AFRIJAM *
* Freelance Coding *

[jamesd116]

dagilli:

make sure to have: dbVerifyTable($jamroom_db['rt_********'],$tbl); at the end of all the CREATE TABLE statements in the schema.php Of course the ****** is your new table names....

Yes its there on all 3 tables


_________________
One day the court system will learn that a childs mother is not the only option...... Question is will it be too late by that time...

[jamesd116]

Here is the code I have right now if something looks wrong please tell me

Code

<?php /**  * Jamroom rtCreator module Schema file  * @copyright 2009 by 4Spotlight.com  * @author James Dallas - admin_support@ecmunlimited.com  */ defined('IN_JAMROOM') or exit(); // library $tbl = "CREATE TABLE {$jamroom_db['rt_library']} (   memberid INT(14) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,    extension VARCHAR(255) NOT NULL DEFAULT '',    name VARCHAR(255) NOT NULL DEFAULT '',    user VARCHAR(255) NOT NULL DEFAULT '',   filename VARCHAR(255) NOT NULL DEFAULT '',    servername VARCHAR(255) NOT NULL DEFAULT '',   length VARCHAR(255) NOT NULL DEFAULT '',   PRIMARY KEY (MEMBERID)) "; dbVerifyTable($jamroom_db['rt_library'],$tbl); // carriers $tbl = "CREATE TABLE {$jamroom_db['rt_carriers']} (   number INT(14) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,    extension VARCHAR(255) NOT NULL DEFAULT '',    name VARCHAR(255) NOT NULL DEFAULT '',    PRIMARY KEY (NUMBER)) "; dbVerifyTable($jamroom_db['rt_carriers'],$tbl); // userips $tbl = "CREATE TABLE {$jamroom_db['rt_userips']} (   number INT(14) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,    ip VARCHAR(255) NOT NULL DEFAULT '',    hits VARCHAR(255) NOT NULL DEFAULT '',    time VARCHAR(100) NOT NULL DEFAULT '',   PRIMARY KEY (NUMBER)) "; dbVerifyTable($jamroom_db['rt_userips'],$tbl); // Jamroom Quota $tbl = "   quota_rtCreator_access CHAR(3) NOT NULL DEFAULT 'no' "; dbVerifyTable($jamroom_db['quota'],$tbl); fdebug($jamroom_db); ?>

_________________
One day the court system will learn that a childs mother is not the only option...... Question is will it be too late by that time...

[smith.kyle]

Does your quota_rtCreator_access column get added to the Quota table?


_________________
kyle[at]jamroom.net

Yes...that's a soda machine...

I get bored when no one's posting...