SA-MP Forums

Go Back   SA-MP Forums > SA-MP Server > Server Support

Reply
 
Thread Tools Display Modes
Old 24/05/2017, 02:29 PM   #1
TitoFreeman
Little Clucker
 
Join Date: Feb 2016
Location: Egypt , Cairo
Posts: 2
Reputation: 0
Default MYSQL help

:53:21] SELECT `gMOTD`,`aMOTD`,`vMOTD`,`famedMOTD`,`cMOTD`,`pMOTD `,`ShopTechPay`,`GiftCode`,`GiftCodeBypass`,`Total Citizens`,`TRCitizens`,`SecurityCode`,`ShopClosed` ,`RimMod`,`CarVoucher`,`PVIPVoucher`, `GarageVW`, `PumpkinStock`, `HalloweenShop` FROM `misc`
[04:53:21] [Dynamic Giftbox] Successfully loaded the dynamic giftbox.
[04:53:21] [LoadCrates] Loading Crates Finished
[04:53:21] [LoadHouses] 5000 houses rehashed/loaded.
[04:53:21] [LoadDynamicDoors] 3000 doors rehashed/loaded.
[04:53:21] [LoadDynamicMapIcons] 400 map icons rehashed/loaded.
[04:53:21] [LoadMailboxes] 50 mailboxes rehashed/loaded.
[04:53:21] [LoadBusinesses] 200 businesses rehashed/loaded.
[04:53:21] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[04:53:21] [MySQL] Check mysql_log.txt to review the query that threw the error.
[04:53:21] Dumping query from 2017/5/24 (4:53:21)
Description: Table 'sgrp1.atms' doesn't exist (index 0). Query:

[04:53:21] SELECT * FROM `atms`
[04:53:21] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[04:53:21] [MySQL] Check mysql_log.txt to review the query that threw the error.
[04:53:21] Dumping query from 2017/5/24 (4:53:21)
Description: Table 'sgrp1.payphones' doesn't exist (index 0). Query:

[04:53:21] SELECT * FROM `payphones`
[04:53:21] [LoadPlants] Successfully loaded 300 plants
[04:53:21] [SpeedCameras] Loaded 4 Speed Cameras.
[04:53:21] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[04:53:21] [MySQL] Check mysql_log.txt to review the query that threw the error.
[04:53:21] Dumping query from 2017/5/24 (4:53:21)
Description: Table 'sgrp1.statlockers' doesn't exist (index 0). Query:

How to fix this error guys?
TitoFreeman is offline   Reply With Quote
Old 24/05/2017, 04:18 PM   #2
fatlirmorina
Big Clucker
 
Join Date: Nov 2013
Posts: 70
Reputation: 1
Default Re: MYSQL help

Tables aren't created in the DB.
fatlirmorina is offline   Reply With Quote
Old 24/05/2017, 04:30 PM   #3
AlexMSK
Banned
 
Join Date: Apr 2016
Location: Albania, yez
Posts: 203
Reputation: 61
Default Re: MYSQL help

Code:
Description: Table 'sgrp1.statlockers' doesn't exist (index 0). Query:
Description: Table 'sgrp1.payphones' doesn't exist (index 0). Query:
Description: Table 'sgrp1.atms' doesn't exist (index 0). Query:
Dont you understand? Those tables doesnt exists, you must create it..
AlexMSK is offline   Reply With Quote
Old 25/05/2017, 01:31 PM   #4
TitoFreeman
Little Clucker
 
Join Date: Feb 2016
Location: Egypt , Cairo
Posts: 2
Reputation: 0
Default Re: MYSQL help

How to create it?
TitoFreeman is offline   Reply With Quote
Old 25/05/2017, 03:52 PM   #5
Yuri8
Big Clucker
 
Join Date: Nov 2016
Posts: 71
Reputation: 2
Exclamation Re: MYSQL help

Quote:
Originally Posted by TitoFreeman View Post
How to create it?
From PhpMyAdmin or CREATE TABLE ...

Search the web.
Yuri8 is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Plugin r39-2 Error: Can't connect to local MySQL server through socket Emre__ Scripting Help 10 30/07/2014 08:26 AM
[Tutorial] [VIDEO] MySQL ORM r38: How to pair GM with MySQL & creation of registration/connection system cArnasLT Tutorials 3 19/05/2014 02:08 PM
BlueG MySQL plugin - Failed (plugins/mysql.so: undefined symbol: _Z13stringvprintfPKcPc) linuxthefish Plugin Development 10 13/07/2013 10:56 AM
[Tool/Web/Other] MySQL DB Manager - Easily manage your MySQL databases with this remote application fiki574 Tools and Files 13 22/07/2012 09:41 AM


All times are GMT. The time now is 07:43 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.