Okay for my site www.fantasy-pc.com . I created a new Database called xxxxxx_smftest . I am testing the SMF forum software. I have an old Database called xxxxxx_phpnuke . That is my main Database that I am using. I am using the phpnuke_to_smf converter for the MySQL DB. I have to copy the entire _phpnuke DB to the new _smftest DB. I used the export and import functions and it didn't work. So I tried clicking the Operations tab. I went down to "Copy database to". Entered the correct name "smftest" . Also checked the box for "Structure and Data" and unchecked "CREATE DATABASE before copying" becuase I already have a database. Anyways it gives me this error: Error SQL query: Edit CREATE TABLE `smftest`.`nukefc_bans` ( `created` timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP , `userid` int( 11 ) default NULL , `banneduserid` int( 11 ) default NULL , `roomid` int( 11 ) default NULL , `ip` varchar( 16 ) default NULL , KEY `userid` ( `userid` ) , KEY `created` ( `created` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1 MySQL said: Documentation #1142 - CREATE command denied to user 'ratman'@'localhost' for table 'nukefc_bans' Code (markup): How do I fix it? The directory I am using for testing the SMF forum is at : www.fantasy-pc.com/forumsmf . P.S. Disregard that is says at the top "MAJOR SECURITY RISK : Did not delete convert.php" That is because I haven't finished converting.
There is an smf convertor that you need to use located here: http://www.simplemachines.org/download/index.php?thanks;filename=smf_1-1-2_phpnuke_converter.zip That will do it for you if you follow the instructions exactly. Hope this helps.
your user doesn't have the right priviliges to create tables,talk to your admin about this,let him read this error
Well as I said above : "I am using the phpnuke_to_smf converter for the MySQL DB." I already downloaded that, and am following the instructions correctly until this point. I am the admin, to you mean by webhosting company? Anyways, I would approach my Co-Admin of the site, he is an expert programmer, so he knows how to fix this up, but he is on vacation . So any other advice?
Ok I am using bigdump now to import the database. I am afraid it is successful and it is uploading but a file is corrupt or something. It uploads a part of the nuke tables into the new DB but then it stops and gives this error: BigDump: Staggered MySQL Dump Importer v0.27b Processing file: ratman_phpnuke.sql Starting from line: 12001 Error at the line 12096: parent.document.title = 'www.fantasy-pc.com / localhost / ratman_phpnuke / nuke_bbprivmsgs | phpMyAdmin 2.9.0.2'; Query: <br> <b>Warning</b>: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php:150) in <b>/usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/ob.lib.php</b> on line <b>61</b><br> <br> <b>Warning</b>: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php:150) in <b>/usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_http.inc.php</b> on line <b>13</b><br> <br> <b>Warning</b>: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php:150) in <b>/usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_http.inc.php</b> on line <b>14</b><br> <br> <b>Warning</b>: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php:150) in <b>/usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_http.inc.php</b> on line <b>15</b><br> <br> <b>Warning</b>: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php:150) in <b>/usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_http.inc.php</b> on line <b>16</b><br> <br> <b>Warning</b>: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php:150) in <b>/usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_http.inc.php</b> on line <b>19</b><br> <DOCTYPE> <html> <head> <link> <link> <title>phpMyAdmin</title> <meta> <link> <link> <script> // <![CDATA[ // Updates the title of the frameset if possible (ns4 does not allow this) if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown' && typeof(parent.document.title) == 'string') { parent.document.title = 'www.fantasy-pc.com / localhost / ratman_phpnuke / nuke_bbprivmsgs | phpMyAdmin 2.9.0.2'; MySQL: 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 ' Warning: Cannot modify header information - headers already sent ' at line 1 Stopped on error Code (markup):
no what is happening is that it seems as though you are not using the same username and pass that was in the old db. according to your post before this one. The next post that you have made about the header already being sent is usually caused by having a white space before or after the opening and closing PHP tags (<?php . . . ?>). Have you recently edited any files?
well it is not really an old database. I am just moving this db to a new one. I have the same password but how can the username be the same? I have recently edited files. But I am not sure what to fix. I can give someone my admin access if they can help fix this for me please!
If you are converting to a new DB you have to access the old DB with the correct username and pass. That is why the first error was occurring. The other error, you need to back track what pages it was that you edited. PM me and I will lend you a hand.