Adding sql database inserts to phpbb3.0 Install Script

[bbrian017]

Hmm...I smell a points system being added to the premod!

Database inserts go into install/database_update.php. Find the line below, and you'll see where your first SQL line needs to go.

Code: Select all

// add the various statements    Â      

The second line, is altering the table. Shouldn't be necessary, since you're installing phpBB for the first time. So you can jsut add it to the table creation. The SQL files are in the install\schemas folder. For instance, you have the mysql_40_schema.sql.

Code: Select all

#
#-----[ FIND ]------------------------------------------
#

# Table: 'phpbb_users'

#
#-----[ FIND ]------------------------------------------
#

user_newpasswd varbinary(96) DEFAULT '' NOT NULL,

#
#-----[ AFTER, ADD ]------------------------------------------
#

user_points int(11) DEFAULT '0' NOT NULL



eviL <3 do I still need to do this part as well?

[igorw]

Yes, that's another SQL command...

[bbrian017]

Alright I continue to get this error and this is how i have the files edited now

mysql_40_schema.sql

Code: Select all

user_newpasswd varbinary(96) DEFAULT '' NOT NULL,
 user_points int(11) DEFAULT '0' NOT NULL,   PRIMARY KEY (user_id),
   KEY user_birthday (user_birthday),

and i also have this Schema data.sql

Code: Select all

;INSERT INTO phpbb_extensions (group_id, extension) VALUES (9, 'ogg');
INSERT INTO phpbb_extensions (group_id, extension) VALUES (9, 'ogm');# MOD: SIMPLE POINTS SYSTEM
INSERT INTO phpbb_acl_options( auth_option, is_global, is_local ) VALUES ('f_points', 0, 1);# POSTGRES COMMIT #

Code: Select all

A fatal and unrecoverable database error has occurred. This may be because the specified user does not have appropriate permissions to CREATE TABLES or INSERT data, etc. Further information may be given below. Please contact your hosting provider in the first instance or the support forums of phpBB for further assistance.

install_install.php [ 1214 ]

SQL : INSERT INTO phpbb_extensions (group_id, extension) VALUES (9, 'ogm');# MOD: SIMPLE POINTS SYSTEM INSERT INTO phpbb_acl_options( auth_option, is_global, is_local ) VALUES ('f_points', 0, 1);# POSTGRES COMMIT #

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 ';# MOD: SIMPLE POINTS SYSTEM INSERT INTO phpbb_acl_options( auth_option, is_glob' at line 1

I really appreciate this help guys

[igorw]

Code: Select all

    INSERT INTO phpbb_extensions (group_id, extension) VALUES (9, 'ogm');# MOD: SIMPLE POINTS SYSTEM
    INSERT INTO phpbb_acl_options( auth_option, is_global, is_local ) VALUES ('f_points', 0, 1);# POSTGRES COMMIT #

Should be:

Code: Select all

    INSERT INTO phpbb_extensions (group_id, extension) VALUES (9, 'ogm');
# MOD: SIMPLE POINTS SYSTEM
    INSERT INTO phpbb_acl_options( auth_option, is_global, is_local ) VALUES ('f_points', 0, 1);

[bbrian017]

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Unknown column 'user_points' in 'field list' [1054]

SQL

UPDATE phpbb_users SET user_points = user_points + 1 WHERE user_id = 2

BACKTRACE


FILE: includes/db/mysql.php
LINE: 133
CALL: dbal_mysql->sql_error()

FILE: includes/mods/functions_points.php
LINE: 27
CALL: dbal_mysql->sql_query()

FILE: posting.php
LINE: 968
CALL: add_points()

This hapens when I try and post ? I'm assuming this is because one the the sql actions didn't go through. You will be happy to know that the error is gone during the install which is a good thing. Any suggestions on why this is happening

[Ganon_Master]

You have to add this line to all the files in the /install/schemas folder:(except schema_data.sql)

Code: Select all

 user_points int(11) DEFAULT '0' NOT NULL

[bbrian017]

from the error message do you think the other command went through in the database alright?

and does it matter where I add it in every file because your find, isn't always there

[Ganon_Master]

from the error message do you think the other command went through in the database alright?

No. The error says that PHP tried to find the user_points field in the database, but couldn't find it.

and does it matter where I add it in every file because your find, isn't always there

Search for similair lines.

[bbrian017]

Thanks guys it works perfect

[poyntesm]

If you are adding lots of tables or new field i HIGHLY recommend you look at create_schema_files.php in the /develop folder in the CVS.

In there you store the schema as an array and then let the script generate the schema files. This is better than editing the schema files as datatypes can be different across the DBMS that phpBB supports.

[Lord Le Brand]

good thing i was bored and checked this topic
Thanks for that tip poyntesm! VERY useful for phpBB Project

[poyntesm]

Yes, very important. I have a post nearly ready on it all.