Create new table with MySQL

[bosswhite]

I have encountered many problems trying to install a mod through package manager so have resorted to a manual install.

I don't have any problem modifying the necessary files or uploading new files but there is one issue I am having.
The mod contains an install file which should create a new table in my database. The code from that file is shown below.

Code Select Expand

<?php
global $db_prefix, $smcFunc;

$smcFunc['db_create_table']($db_prefix . 'bookmarks',
array(
array(
'name' => 'id_member',
'type' => 'mediumint',
'size' => 8,
),
array(
'name' => 'id_topic',
'type' => 'mediumint',
'size' => 8,
),
),
array(
array(
'name' => 'bookmark',
'type' => 'unique',
'columns' => array('id_member', 'id_topic'),
),
),
array(),
'ignore');
?>

I need to create that table with an SQL query when logged in to my database but don't know how to do it.

Could anybody possibly convert the content of the file above in to an SQL query for me that would create what is required?

I am on an Apache server running MySQL 5.1.73 and the prefix to all my tables is smf_.

Any help would be gratefully appreciated. Thank you.

[vbgamer45]

Easy way is just to run that script
after

Code Select Expand


<?php

Add

Code Select Expand


require 'SSI.php';


Then copy that file to main directory of your forum then run it in browser by visiting the page in the address bar.

[bosswhite]

Easy way is just to run that script
after

Code Select Expand


<?php

Add

Code Select Expand


require 'SSI.php';


Then copy that file to main directory of your forum then run it in browser by visiting the page in the address bar.

I just tried that and get the following error message
Fatal error: Function name must be a string in /home/mysite/Z6OW6C36/htdocs/forum/install.php on line 7

[vbgamer45]

What SMF version are you using?

[bosswhite]

What SMF version are you using?

SMF 2.0.9

The mod was written for 2.0.2, would that make a difference?
I notice that if you parse the mod for manual installation it doesn't mention the new table.
http://custom.simplemachines.org/mods/index.php?mod=864

[Illori]

smf20/install.php
This file should not be able to execute standalone. You may have to run the following queries manually.

that is the part about the database table from the parse of that mod.

[bosswhite]

smf20/install.php
This file should not be able to execute standalone. You may have to run the following queries manually.

that is the part about the database table from the parse of that mod.

Right, I understand.
So that takes me back to the original question about running the queries in SQL?

[bosswhite]

Not sure why this topic was moved from Scripting Board. I require assistance writing a SQL query which that board covers.

I don't think my issue is a problem with SMF Coding, but that is just my opinion.

I just want help to create a SQL query that will create the table as shown in the original post.

[bosswhite]

Solved. The query I required was

Code Select Expand

CREATE TABLE smf_bookmarks (id_member MEDIUMINT(8), id_topic MEDIUMINT(8), PRIMARY KEY(id_member,id_topic));