[JasonRiggs]

Hi folks,

So before searching in the script for this bug's reason I want to know what would cause it..? As the password dialog ain't showing up.

sa-mp-015.jpg

Thanks in advance.

[Misiur]

Query error, script stuck somewhere and not executing further, server crash. Top 3 causes in no particular order

(or you forgot to call function showing the dialog lol)

[JasonRiggs]

Quote:

Originally Posted by Misiur Query error, script stuck somewhere and not executing further, server crash. Top 3 causes in no particular order (or you forgot to call function showing the dialog lol)

I'm pretty sure the bug between brackets ain't right,as the server worked before with the same script, and I've just re downloaded the package, so, I don't know what would cause that?

[Misiur]

Part before brackets still stands. If server crashes and you are using crashdetect you should see crash in log immediately. Check mysql_log to see if query failed. I doubt the code is stuck, so first check first two options

[MEW273]

Perhaps the database isn't connecting correctly?

Have you checked your server log and database/storage (MySQL or other) logs for errors?

[JasonRiggs]

I've got weird thing now, In the server logs it says like that..

Quote:

[12:50:04] SUCCESS: Connected To MySQL! [12:50:04] Connected to MySQL werd up. [12:50:04] Loaded Mapfile: block-gates.ini - 11 Objects - WorldID: 0. [12:50:05] Loaded Mapfile: stripmall.ini - 159 Objects - WorldID: 0. [12:50:05] Loaded Mapfile: pdgates.ini - 16 Objects - WorldID: 0. [12:50:07] Loaded Mapfile: mapfix.ini - 6 Objects - WorldID: 0. [12:50:08] Loaded Mapfile: hospital.ini - 1492 Objects - WorldID: 0. [12:50:08] Loaded Mapfile: lspd.ini - 888 Objects - WorldID: 0. [12:50:09] Loaded Mapfile: app2.ini - 266 Objects - WorldID: -1. [12:50:09] Loaded Mapfile: app3.ini - 256 Objects - WorldID: -1. [12:50:09] Loaded Mapfile: pdtr1.ini - 485 Objects - WorldID: 0. [12:50:09] Loaded Mapfile: pdtr2.ini - 163 Objects - WorldID: 0. [12:50:10] Loaded Mapfile: cityhall.ini - 295 Objects - WorldID: 1. [12:50:10] Loaded Mapfile: bank.ini - 176 Objects - WorldID: 0. [12:50:10] Loaded Mapfile: idlewoodhousing.ini - 42 Objects - WorldID: 0. [12:50:10] Loaded Mapfile: sannews.ini - 235 Objects - WorldID: 1. [12:50:11] Loaded Mapfile: sannewsex.ini - 9 Objects - WorldID: 0. [12:50:11] Loaded Mapfile: ganton.ini - 198 Objects - WorldID: 0. [12:50:12] Loaded Mapfile: rlsint.ini - 322 Objects - WorldID: 0. [12:50:12] Loaded Mapfile: gantonint.ini - 256 Objects - WorldID: 7. [12:50:12] Loaded Mapfile: prisonint.ini - 891 Objects - WorldID: 1. [12:50:12] Loaded Mapfile: prison.ini - 278 Objects - WorldID: 0. [12:50:17] Loaded Mapfile: traphouse.ini - 152 Objects - WorldID: -1. [12:50:17] Loaded Mapfile: clubint.ini - 279 Objects - WorldID: 10. [12:50:19] Loaded Mapfile: boatdealer.ini - 6 Objects - WorldID: 0. [12:50:19] Loaded Mapfile: projects.ini - 74 Objects - WorldID: 0. [12:50:19] Loaded Mapfile: church.ini - 289 Objects - WorldID: 1. [12:50:20] [Diverse RP]: 7328 Streamed Objects Loaded. [12:50:20] [Diverse RP]: 80 Streamed Pickups Loaded. [12:50:20] [Diverse RP]: 19 Streamed Checkpoints Loaded. [12:50:20] [Diverse RP]: 88 Streamed Map Icons Loaded. [12:50:20] [Diverse RP]: 71 Streamed 3D-Textes Loaded. [12:50:20] Resetting online players. [12:50:20] LAUNCHED Diverse RP v2.0.9!

Cute enough no?

Watch this, in the mysql_log it says..

Quote:

[12:50:05] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: NO)

The more weird thing is that there is no "root" word in the .sql file imported while I've tried to edit it, What to do?

[Misiur]

I think root will be used when no username is provided to the connection. Show your connection code

[MEW273]

It looks like you are entering incorrect MySQL connection details, you should check the details are correct in your script at mysql_connect.

[JasonRiggs]

If you mean the .sql file, here is it..

PHP код:

CREATE DATABASE  IF NOT EXISTS `seifdb` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `seifdb`;
-- MySQL dump 10.13  Distrib 5.6.23, for Win64 (x86_64)
--
-- Host: http://185.12.178.71/phpmyadmin/   Database: seifdb
-- ------------------------------------------------------
-- Server version    5.6.24-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `accounts`
--

DROP TABLE IF EXISTS `accounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accounts` 


That's the first part of it, the rest is regarding creating tables..

[MEW273]

You need to check the actual gamemode script where the connection is made, search for the function mysql_connect.

It is common that the connection details may be defined somewhere else in the script and then used at mysql_connect, they could be near the top of your script and defined as MYSQL_HOST, MYSQL_PASSWORD etc. or similar.