problema con mi mysql

Descripcion de mi problema:

mi base de datos

---

Imagen de mi Error:


Mi problema esta en:
Otro Problema

z_ots_comunication
le falta a su base de datos ejecute esta tabla en su base de datos mysql logea en tu php admin y se va a la pestaña sql y ejecuta esta linea

Código:


CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=230 ;


bro no se puede me sale error entre en mi phamyadmin y ledi en mi base y a sql pegue eso y mesale un error

que error saca un capture

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem.

ERROR: Unknown Punctuation String @ 806
STR: ://
SQL:
CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`type` varchar(255) NOT NULL,
`action` varchar(255) NOT NULL,
`param1` varchar(255) NOT NULL,
`param2` varchar(255) NOT NULL,
`param3` varchar(255) NOT NULL,
`param4` varchar(255) NOT NULL,
`param5` varchar(255) NOT NULL,
`param6` varchar(255) NOT NULL,
`param7` varchar(255) NOT NULL,
`delete_it` int(2) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=230 ;# MySQL returned an empty result set (i.e. zero rows).
- See more at: http://www.tibiaface.com/t1013-problema-con-mi-mysql#sthash.omA7UYLm.dpuf


SQL query:

- See more at: http://www.tibiaface.com/t1013-problema-con-mi-mysql#sthash.omA7UYLm.dpuf

MySQL said: Documentation
#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 '- See more at: http://www.tibiaface.com/t1013-problema-con-mi-mysql#sthash.omA7U' at line 1

dementeser escribió:Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem.

ERROR: Unknown Punctuation String @ 806
STR: ://
SQL:
           CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
             `id` int(11) NOT NULL AUTO_INCREMENT,
             `name` varchar(255) NOT NULL,
             `type` varchar(255) NOT NULL,
             `action` varchar(255) NOT NULL,
             `param1` varchar(255) NOT NULL,
             `param2` varchar(255) NOT NULL,
             `param3` varchar(255) NOT NULL,
             `param4` varchar(255) NOT NULL,
             `param5` varchar(255) NOT NULL,
             `param6` varchar(255) NOT NULL,
             `param7` varchar(255) NOT NULL,
             `delete_it` int(2) NOT NULL DEFAULT '1',
             PRIMARY KEY (`id`)
           ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=230 ;# MySQL returned an empty result set (i.e. zero rows).
- See more at: http://www.tibiaface.com/t1013-problema-con-mi-mysql#sthash.omA7UYLm.dpuf


SQL query:

- See more at: http://www.tibiaface.com/t1013-problema-con-mi-mysql#sthash.omA7UYLm.dpuf

MySQL said: Documentation
#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 '- See more at: http://www.tibiaface.com/t1013-problema-con-mi-mysql#sthash.omA7U' at line 1

es posible que tu problema sea que se ala version no compatible cual esa tabla se carga autoamticamente cuando instalas la gesior te recomiendo usar xampp 1.7.3

okey bro gracias lo descargare jejej

dementeser escribió:okey bro gracias lo descargare jejej

ante spuede probar ejecutando esta otra tabla pruebe

Código:

CREATE TABLE `z_ots_comunication` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`type` VARCHAR(255) NOT NULL,
`action` VARCHAR(255) NOT NULL,
`param1` VARCHAR(255) NOT NULL,
`param2` VARCHAR(255) NOT NULL,
`param3` VARCHAR(255) NOT NULL,
`param4` VARCHAR(255) NOT NULL,
`param5` VARCHAR(255) NOT NULL,
`param6` VARCHAR(255) NOT NULL,
`param7` VARCHAR(255) NOT NULL,
`delete_it` INT(2) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

​

Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Run SQL query/queries on database prueb: Documentation

1

CREATE TABLE `z_ots_comunication` (

2

`id` INT(11) NOT NULL AUTO_INCREMENT,

3

`name` VARCHAR(255) NOT NULL,

4

`type` VARCHAR(255) NOT NULL,

5

`action` VARCHAR(255) NOT NULL,

6

`param1` VARCHAR(255) NOT NULL,

7

`param2` VARCHAR(255) NOT NULL,

8

`param3` VARCHAR(255) NOT NULL,

9

`param4` VARCHAR(255) NOT NULL,

10

`param5` VARCHAR(255) NOT NULL,

11

`param6` VARCHAR(255) NOT NULL,

12

`param7` VARCHAR(255) NOT NULL,

13

`delete_it` INT(2) NOT NULL DEFAULT '1',

14

PRIMARY KEY (`id`)

15

) ENGINE=MyISAM DEFAULT CHARSET=latin1

16

​

17

- See more at: http://www.tibiaface.com/t1013-problema-con-mi-mysql#5601

Bookmark this SQL query:
[ Delimiter ]Show this query here againRetain query boxRollback when finished
Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem.

ERROR: Unknown Punctuation String @ 691
STR: ://
SQL: CREATE TABLE `z_ots_comunication` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`type` VARCHAR(255) NOT NULL,
`action` VARCHAR(255) NOT NULL,
`param1` VARCHAR(255) NOT NULL,
`param2` VARCHAR(255) NOT NULL,
`param3` VARCHAR(255) NOT NULL,
`param4` VARCHAR(255) NOT NULL,
`param5` VARCHAR(255) NOT NULL,
`param6` VARCHAR(255) NOT NULL,
`param7` VARCHAR(255) NOT NULL,
`delete_it` INT(2) NOT NULL DEFAULT '1',

PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

- See more at: http://www.tibiaface.com/t1013-problema-con-mi-mysql#5601


SQL query:

CREATE TABLE `z_ots_comunication` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `type` VARCHAR(255) NOT NULL, `action` VARCHAR(255) NOT NULL, `param1` VARCHAR(255) NOT NULL, `param2` VARCHAR(255) NOT NULL, `param3` VARCHAR(255) NOT NULL, `param4` VARCHAR(255) NOT NULL, `param5` VARCHAR(255) NOT NULL, `param6` VARCHAR(255) NOT NULL, `param7` VARCHAR(255) NOT NULL, `delete_it` INT(2) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - See more at: http://www.tibiaface.com/t1013-problema-con-mi-mysql#5601

MySQL said: Documentation
#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 '- See more at: http://www.tibiaface.com/t1013-problema-con-mi-mysql#5601' at line 18
Open new phpMyAdmin window

sigue con error bueno prueba con el xampp que te dije

bro descarge el xap pero dice este error Error: Apache shutdown unexpectedly.
08:40:28 p. m. [Apache] This may be due to a blocked port, missing dependencies,
08:40:28 p. m. [Apache] improper privileges, a crash, or a shutdown by another method.
08:40:28 p. m. [Apache] Press the Logs button to view error logs and check
08:40:28 p. m. [Apache] the Windows Event Viewer for more clues
08:40:28 p. m. [Apache] If you need more help, copy and post this
08:40:28 p. m. [Apache] entire log window on the forums

dementeser escribió:bro descarge el xap pero dice este error Error: Apache shutdown unexpectedly.
08:40:28 p. m.  [Apache] This may be due to a blocked port, missing dependencies,
08:40:28 p. m.  [Apache] improper privileges, a crash, or a shutdown by another method.
08:40:28 p. m.  [Apache] Press the Logs button to view error logs and check
08:40:28 p. m.  [Apache] the Windows Event Viewer for more clues
08:40:28 p. m.  [Apache] If you need more help, copy and post this
08:40:28 p. m.  [Apache] entire log window on the forums

seguramente es por que otro programa esta usando el puerto 80 tienes que cerrar todos los programas que esten usando el puerto 80