WAMP vs XAMPP Question

Alles, was PHP betrifft, kann hier besprochen werden.

Re: WAMP vs XAMPP Question

Postby cover » 16. January 2013 07:14

Altrea wrote:What was the full error message you get?
Your code contains just a simple INSERT query, so i can't believe this is a InnoDB issue (exept you are getting constraint integrety messages, which is at the end not the fault of InnoDB but of your way to insert data into it - changing to MyISAM instead just destroys the integrety).


I deleted and re-created the database and table.

The error read:

"MySQL Error (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 'event message content was here' at line 1"

So I read the MySQL error log:
Code: Select all
130115 20:27:57 [Note] Plugin 'FEDERATED' is disabled.
130115 20:27:57 InnoDB: The InnoDB memory heap is disabled
130115 20:27:57 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130115 20:27:57 InnoDB: Compressed tables use zlib 1.2.3
130115 20:27:57 InnoDB: Initializing buffer pool, size = 128.0M
130115 20:27:57 InnoDB: Completed initialization of buffer pool
130115 20:27:57 InnoDB: highest supported file format is Barracuda.
130115 20:27:58  InnoDB: Waiting for the background threads to start
130115 20:27:59 InnoDB: 1.1.8 started; log sequence number 1769800
130115 20:27:59 [Note] Server hostname (bind-address): '(null)'; port: 3306
130115 20:27:59 [Note]   - '(null)' resolves to '::';
130115 20:27:59 [Note]   - '(null)' resolves to '0.0.0.0';
130115 20:27:59 [Note] Server socket created on IP: '0.0.0.0'.
130115 20:27:59 [Note] Event Scheduler: Loaded 0 events
130115 20:27:59 [Note] mysqld: ready for connections.
Version: '5.5.24-log'  socket: ''  port: 3306  MySQL Community Server (GPL)

and the contents of my.ini associated with InnoDB that I tried to UNcomment
Code: Select all
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:\mysql\data/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = C:\mysql\data/
#innodb_log_arch_dir = C:\mysql\data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50


I knew of another guy who used MyISAM albeit on an older version of MySQL so thought I'd give it a try since I couldn't get the UNcomment fo work out.
cover
 
Posts: 19
Joined: 24. December 2012 14:15
Operating System: Windows 7 64bit

Re: WAMP vs XAMPP Question

Postby Altrea » 16. January 2013 17:06

cover wrote:The error read:

"MySQL Error (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 'event message content was here' at line 1"

Great. Now you have to compare the Error message in relation with the full real SQL statement (after it is processed by PHP), which you already echo between your <hr> Tags if i remember.

We can't help you that much here because we don't know the full real SQL statement and the database table structure.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8293
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: WAMP vs XAMPP Question

Postby cover » 16. January 2013 21:28

Thanks Altrea... Interesting significance is that 'event' was a varchar(250) and one thing I'd noticed before was that shorter messages i.e. 50 to 75 characters didn't fail as often as a message closer to the 250 mark.

On the "# Uncomment the following if you are using InnoDB tables" message above this message, do you think they want every line's hash mark removed below the header (# Uncomment the following if you are using InnoDB tables) for InnoDB tables ??? I wondered if that was a problem with the InnoDB table before I changed to MyISAM. I can change back easy enough since I'm not that far into it but was wondering about it.
cover
 
Posts: 19
Joined: 24. December 2012 14:15
Operating System: Windows 7 64bit

Re: WAMP vs XAMPP Question

Postby Altrea » 16. January 2013 22:13

cover wrote:Thanks Altrea... Interesting significance is that 'event' was a varchar(250) and one thing I'd noticed before was that shorter messages i.e. 50 to 75 characters didn't fail as often as a message closer to the 250 mark.

Okay...!? Can't say anything more to this unspecific "information", sorry :(

cover wrote:On the "# Uncomment the following if you are using InnoDB tables" message above this message, do you think they want every line's hash mark removed below the header (# Uncomment the following if you are using InnoDB tables) for InnoDB tables ???

Why don't you take a look into XAMPPs default my.ini file?
The related parts are already uncommented and configurated there.

cover wrote:I wondered if that was a problem with the InnoDB table before I changed to MyISAM.

I still can't see any problem with InnoDB.

best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8293
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: WAMP vs XAMPP Question

Postby cover » 17. January 2013 03:00

wow, some interesting differences in the my.ini files between XAMPP and WAMP. One reads "# Comment the following if you are using InnoDB tables" and the other, "# Uncomment the following if you are using InnoDB tables" - thanks for the idea of checking.

Perhaps a silly question but I'm under the assumption that all that needs to be done to comment or uncomment is add or remove the hash mark (#) at the beginning of the line to have that line read (or not), correct?
cover
 
Posts: 19
Joined: 24. December 2012 14:15
Operating System: Windows 7 64bit

Re: WAMP vs XAMPP Question

Postby Altrea » 17. January 2013 05:46

cover wrote:wow, some interesting differences in the my.ini files between XAMPP and WAMP. One reads "# Comment the following if you are using InnoDB tables" and the other, "# Uncomment the following if you are using InnoDB tables" - thanks for the idea of checking.

We can't provide any support for third party programs like WAMPServer.
The comment in the XAMPP my.ini must be a typo. The parts ARE uncommented because MySQL5.5 default storage engine is InnoDB.

cover wrote:Perhaps a silly question but I'm under the assumption that all that needs to be done to comment or uncomment is add or remove the hash mark (#) at the beginning of the line to have that line read (or not), correct?

XAMPP is preconfigurated to work with InnoDB, so there is nothing to do.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8293
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: WAMP vs XAMPP Question

Postby cover » 17. January 2013 06:04

Got it... There's a story behind my use of both but it's off topic enough so... lol

Thanks again for your help Altrea - you've been great and it's very much appreciated...
cover
 
Posts: 19
Joined: 24. December 2012 14:15
Operating System: Windows 7 64bit

Previous

Return to PHP

Who is online

Users browsing this forum: No registered users and 2 guests