MySQL Error

Discutii despre tot ce nu se incadreaza in celelalte categorii.

Moderators: Moderatori ajutatori, Moderatori

Post Reply
User avatar
Adventx
Membru, skill +4
Membru, skill +4
Posts: 1890
Joined: 17 Sep 2013, 20:44
Detinator Steam: Da
Reputatie: Fost moderator ajutator
Has thanked: 125 times
Been thanked: 154 times
Contact:

15 Aug 2014, 15:44

Code: Select all

#1064 - 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 'TYPE=MyISAM' at line 17 
Cum rezolv ? :-/
eXtreamSHOP
User avatar
The Kalu
Membru eXtream
Membru eXtream
Posts: 11953
Joined: 09 Oct 2010, 11:39
Detinator Steam: Da
Reputatie: Fost membru Club eXtreamCS (6 luni)
Restrictie moderator permanent
Restrictie schimbare nume
Nume anterior: Terra
Membrul anului 2017
Has thanked: 108 times
Been thanked: 269 times

15 Aug 2014, 15:59

Si interogarea unde este ca sa nu stim ce ai facut?
User avatar
Adventx
Membru, skill +4
Membru, skill +4
Posts: 1890
Joined: 17 Sep 2013, 20:44
Detinator Steam: Da
Reputatie: Fost moderator ajutator
Has thanked: 125 times
Been thanked: 154 times
Contact:

15 Aug 2014, 16:03

M0hikan eXtream wrote:Si interogarea unde este ca sa nu stim ce ai facut?
Ce interogare? :-/

Eu am baza de date in .sql si cand dau sa o importez imi aparea aceasta eroare sau cand o pun in SQL la fel.
Last edited by Adventx on 15 Aug 2014, 16:05, edited 1 time in total.
User avatar
GPaul
Membru, skill +4
Membru, skill +4
Posts: 1940
Joined: 21 Mar 2009, 12:14
Detinator Steam: Da
CS Status: Inactiv. Studiu intens.
Detinator server CS: - House M.D -
SteamID: - House M.D -
Reputatie: Nume anterior: djxpaulz
Fost super moderator
Location: Cluj-Napoca
Has thanked: 8 times
Been thanked: 173 times
Contact:

15 Aug 2014, 16:04

Query-ul care-l executi, linia 17.
Image
Image
User avatar
Adventx
Membru, skill +4
Membru, skill +4
Posts: 1890
Joined: 17 Sep 2013, 20:44
Detinator Steam: Da
Reputatie: Fost moderator ajutator
Has thanked: 125 times
Been thanked: 154 times
Contact:

15 Aug 2014, 16:06

Paul wrote:Query-ul care-l executi, linia 17.

Code: Select all

-- MySQL dump 9.10
--
-- Host: localhost    Database: ***
-- ------------------------------------------------------
-- Server version	4.0.18-log

--
-- Table structure for table `avps`
Si la linia 17:

Code: Select all

TYPE=MyISAM;
User avatar
The Kalu
Membru eXtream
Membru eXtream
Posts: 11953
Joined: 09 Oct 2010, 11:39
Detinator Steam: Da
Reputatie: Fost membru Club eXtreamCS (6 luni)
Restrictie moderator permanent
Restrictie schimbare nume
Nume anterior: Terra
Membrul anului 2017
Has thanked: 108 times
Been thanked: 269 times

15 Aug 2014, 16:28

Pune tot query-ul ca acelea sunt comenturi.
User avatar
Adventx
Membru, skill +4
Membru, skill +4
Posts: 1890
Joined: 17 Sep 2013, 20:44
Detinator Steam: Da
Reputatie: Fost moderator ajutator
Has thanked: 125 times
Been thanked: 154 times
Contact:

15 Aug 2014, 16:29

M0hikan eXtream wrote:Pune tot query-ul ca acelea sunt comenturi.

Code: Select all

CREATE TABLE avps (
  arg varchar(20) NOT NULL default '',
  value_s text NOT NULL,
  value_i int(11) NOT NULL default '0',
  value_u int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (arg)
) TYPE=MyISAM;
User avatar
The Kalu
Membru eXtream
Membru eXtream
Posts: 11953
Joined: 09 Oct 2010, 11:39
Detinator Steam: Da
Reputatie: Fost membru Club eXtreamCS (6 luni)
Restrictie moderator permanent
Restrictie schimbare nume
Nume anterior: Terra
Membrul anului 2017
Has thanked: 108 times
Been thanked: 269 times

15 Aug 2014, 16:31

Schimba TYPE cu ENGINE si vezi daca functioneaza.
User avatar
Adventx
Membru, skill +4
Membru, skill +4
Posts: 1890
Joined: 17 Sep 2013, 20:44
Detinator Steam: Da
Reputatie: Fost moderator ajutator
Has thanked: 125 times
Been thanked: 154 times
Contact:

15 Aug 2014, 16:39

Merge, dar oricum style nu s-a schimbat deloc, mai am si baza asta de date, am pus-o si nu s-a schimbat nimic :-/

Code: Select all

-- MySQL dump 9.10
--
-- Host: localhost    Database: ***
-- ------------------------------------------------------
-- Server version	4.0.18-log

--
-- Dumping data for table `stylesheets`
--

INSERT INTO stylesheets VALUES (1,'***.css','***');
INSERT INTO stylesheets VALUES (2,'***.css','***');
User avatar
Adventx
Membru, skill +4
Membru, skill +4
Posts: 1890
Joined: 17 Sep 2013, 20:44
Detinator Steam: Da
Reputatie: Fost moderator ajutator
Has thanked: 125 times
Been thanked: 154 times
Contact:

21 Aug 2014, 16:35

M0hikan eXtream wrote:Schimba TYPE cu ENGINE si vezi daca functioneaza.
Care e diferenta dinre TYPE si ENGINE ? E de la versiundea mai noua de PHP ? :-/


Last bumped by Adventx on 21 Aug 2014, 16:35.
Post Reply

Return to “Discutii generale”

  • Information