Posts: 7,801
Threads: 187
Joined: Feb 2010
Reputation:
0
Guys, if you didn't upload the .sql file to the database, you'll get those errors. If you don't know, the tables and database names are case sensitive.
Posts: 138
Threads: 32
Joined: May 2008
Reputation:
0
when i upload it errors
Error
SQL query:
--
-- Database: `sa-mp`
--
-- --------------------------------------------------------
--
-- Table structure for table `CreateDynamicObject`
--
CREATE TABLE IF NOT EXISTS `CreateDynamicObject` (
`model` int( 10 ) NOT NULL ,
`Xpos` varchar( 20 ) NOT NULL ,
`Ypos` varchar( 20 ) NOT NULL ,
`Zpos` varchar( 20 ) NOT NULL ,
`RX` varchar( 20 ) NOT NULL ,
`RY` varchar( 20 ) NOT NULL ,
`RZ` varchar( 20 ) NOT NULL ,
`world` int( 5 ) NOT NULL DEFAULT '-1',
`interior` int( 5 ) NOT NULL DEFAULT '-1',
`playerid` int( 5 ) NOT NULL DEFAULT '-1',
`distance` varchar( 15 ) NOT NULL DEFAULT '200.0',
`immediate` int( 5 ) NOT NULL ,
`ref` varchar( 100 ) NOT NULL ,
`id` int( 15 ) NOT NULL AUTO_INCREMENT ,
`deleted` tinyint( 5 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =161;
MySQL said: Documentation
#1046 - No database selected
Posts: 138
Threads: 32
Joined: May 2008
Reputation:
0
Fixed but when i connect to server i get 10000x
[20:00:36] Error in mysql_query: Unknown column 'Deagle' in 'field list'
on log
Posts: 138
Threads: 32
Joined: May 2008
Reputation:
0
Sory for double i get still same error and my server crash
[13:59:34] Error in mysql_query: Table 'object.players' doesn't exist
[13:59:34] Error in mysql_store_result: Table 'object.players' doesn't exist
i have imported tables.sql to phpmyamin
#define MYSQL_HOST "127.0.0.1"
#define MYSQL_USER "root"
#define MYSQL_PASS ""
#define MYSQL_DB "object"
Posts: 7,801
Threads: 187
Joined: Feb 2010
Reputation:
0
I'm not sure how reliable this will be, but I did a quick ****** search and this is what I found. You should really learn how to use phpMyAdmin and MySQL before even attempting to play with this system.
[ame]http://www.youtube.com/watch?v=1-81n_vuwug[/ame]
Posts: 103
Threads: 16
Joined: Feb 2009
Reputation:
0
Great job! It's a very useful script, thanks!
Posts: 106
Threads: 11
Joined: Jul 2010
Reputation:
0
Doesn't work for me. Objects doesn't appear.
Posts: 84
Threads: 24
Joined: Jul 2009
Reputation:
0
is that the system could also insert vehicles (with the PHP script)?
thanks
Posts: 516
Threads: 153
Joined: Sep 2009
Reputation:
0
When I add objects into it i get ingame ? sign in there but why?
Posts: 25
Threads: 10
Joined: Dec 2010
Reputation:
0
27.08.2011, 04:13
(
Последний раз редактировалось adelechevarria; 27.08.2011 в 04:48.
)
Im lost on
a. Go into the online FTP in your host.
I had created the FTP in my host but theres nothing that says upload I need help plz
4. Lastly the instuctions to use it
i.
a. Go into the main directory of your site and you should find yourself with a page to do with Database information
b. Insert it from earlier when you setup your mysql (Host, user, pass, database) and press submit.
c. If you get a message saying incorrect information, try it again.
d. If the problem persists and you have your MySQL hosted somewhere else (Other than the website host), ask your host to unblock external MySQL connections or you can do it if there is a option in the control panel
ii.
a. After logging in and thinking what a shitty website design you can add some objects.
b. To add a object click the Add objects option on the menu. Chose your format and make a reference (Reference is used to delete later so don't forget it) then insert some objects!
c. If you get the error that the table is missing, make sure you inserted the SQL file into Phpmyadmin and make sure that the tables are the right case (CreateObject instead of createobject)
iii.
a. After getting bored of a map you can delete it by clicking the delete objects link in the menu
b. Put your format and reference number you got before and if your server is running tick the immidiate box
Posts: 548
Threads: 25
Joined: Mar 2011
Reputation:
0
Nice Killer!
Something new :P
Posts: 14
Threads: 3
Joined: Feb 2008
Reputation:
0
Can Other people on the server see the objects too then? Or is it just me?
