Database error when posting "special" characters (ticketed) - Overclock.net - An Overclocking Community

Forum Jump: 

Database error when posting "special" characters (ticketed)

Reply
 
Thread Tools
post #1 of 19 (permalink) Old 02-10-2018, 07:05 AM - Thread Starter
New to Overclock.net
 
LostParticle's Avatar
 
Join Date: Aug 2014
Posts: 2,543
Rep: 98 (Unique: 75)
Database error when posting "special" characters (ticketed)

Hi,

Today I have tried to post a couple of special characters in one of my posts. Those were "μ", "Δ" and "θ".
Each time I try to post these I am getting a database error, as shown in the following screenshot:

Click image for larger version

Name:	err.png
Views:	9
Size:	32.3 KB
ID:	79457


Refreshing the page does nothing. I still get the same error. Then I return to the previous page, I reload the page, and my post with the special characters is posted. Like it will most probably happen with this one.

Thank you.

Intel Core i7-4790K
(27 items)
CPU
Intel Core i7-4790K
Motherboard
ASRock Z97 OC Formula; ASUS MAXIMUS VII HERO; Gigabyte Z97X-SOC Force
GPU
EVGA GTX 1060 SC GAMING 6 GB
RAM
G.SKILL F3-1866C8D-16GTX
Hard Drive
Samsung 850 EVO 250 GB
Hard Drive
SanDisk Extreme Pro 240GB
Hard Drive
Samsung 840 PRO 128GB
Hard Drive
Plextor PX-128M5S 128GB
Hard Drive
WD 1002FAEX 1TB Caviar BLACK (in enclosure)
Power Supply
Corsair AX760 (Platinum); EVGA SuperNova 750 G2
Cooling
Corsair H110
Cooling
2 x Noctua NF-A14 industrialPPC-2000/3000 PWM (Push)
Cooling
Case Fan: 1 x Noctua NF-A14 PWM (rear, exhaust)
Cooling
Case Fan: Noctua NF-S12A PWM (front, intake)
Cooling
Case Fans: 2 x Noctua NF-S12A FLX (front, intake)
Cooling
Noctua NH-D15S
Case
Corsair Air 540
Operating System
Windows 10 Pro 64 bit
Operating System
Windows 10 TP
Operating System
Linux Mint 18.3 Cinnamon
Monitor
HP ZR2440w
Monitor
Dell U2311H
Keyboard
Microsoft Ergonomic keyboard 4000
Audio
Sennheiser HD 600
Audio
Asus Xonar Essence STX II
Other
Aquaero 5LT
Other
THRUSTMASTER GPX LIGHTBACK FERRARI F1 GAMEPAD
▲ hide details ▲
LostParticle is offline  
Sponsored Links
Advertisement
 
post #2 of 19 (permalink) Old 02-11-2018, 01:53 AM - Thread Starter
New to Overclock.net
 
LostParticle's Avatar
 
Join Date: Aug 2014
Posts: 2,543
Rep: 98 (Unique: 75)
Hello OCN staff,

Can anyone of you please confirm / acknowledge this?

Thank you.

Intel Core i7-4790K
(27 items)
CPU
Intel Core i7-4790K
Motherboard
ASRock Z97 OC Formula; ASUS MAXIMUS VII HERO; Gigabyte Z97X-SOC Force
GPU
EVGA GTX 1060 SC GAMING 6 GB
RAM
G.SKILL F3-1866C8D-16GTX
Hard Drive
Samsung 850 EVO 250 GB
Hard Drive
SanDisk Extreme Pro 240GB
Hard Drive
Samsung 840 PRO 128GB
Hard Drive
Plextor PX-128M5S 128GB
Hard Drive
WD 1002FAEX 1TB Caviar BLACK (in enclosure)
Power Supply
Corsair AX760 (Platinum); EVGA SuperNova 750 G2
Cooling
Corsair H110
Cooling
2 x Noctua NF-A14 industrialPPC-2000/3000 PWM (Push)
Cooling
Case Fan: 1 x Noctua NF-A14 PWM (rear, exhaust)
Cooling
Case Fan: Noctua NF-S12A PWM (front, intake)
Cooling
Case Fans: 2 x Noctua NF-S12A FLX (front, intake)
Cooling
Noctua NH-D15S
Case
Corsair Air 540
Operating System
Windows 10 Pro 64 bit
Operating System
Windows 10 TP
Operating System
Linux Mint 18.3 Cinnamon
Monitor
HP ZR2440w
Monitor
Dell U2311H
Keyboard
Microsoft Ergonomic keyboard 4000
Audio
Sennheiser HD 600
Audio
Asus Xonar Essence STX II
Other
Aquaero 5LT
Other
THRUSTMASTER GPX LIGHTBACK FERRARI F1 GAMEPAD
▲ hide details ▲
LostParticle is offline  
post #3 of 19 (permalink) Old 02-11-2018, 06:38 AM
News Fiend
 
ryan92084's Avatar
 
Join Date: Oct 2015
Location: 'merica
Posts: 2,005
test μ Δ θ

edit: Well I'm not staff but I confirm it so you aren't crazy at least.

Meh '12
(13 items)
CPU
Ryzen 2600x
Motherboard
ASUS Crosshair VII Hero
GPU
XFX Fury X
RAM
G.SKILL TridentZ Series 16GB (2 x 8GB) 288-Pin DDR4 SDRAM DDR4 3200 F4-3200C14D-16GTZSW
Hard Drive
SAMSUNG 970 PRO M.2 2280 512GB PCIe Gen3. X4, NVMe
Hard Drive
Samsung 850 Pro-Series
Hard Drive
Seagate 4TB Enterprise NAS SATA (ST4000VN0001)
Hard Drive
WD Black 1TB Performance Desktop Hard Drive WD1003FZEX
Power Supply
SEASONIC PLATINUM-860 860W RT
Cooling
Black Ice Nemesis 360GTS Radiator x2
Cooling
Monsoon MMRS Reservoir + D5 pump + mountings
Cooling
XSPC Raystorm Neo Metal
Cooling
EKWB Fury X
Cooling
Monsoon Free Center 1/2ID 3/4OD fittings + Rotaries + plug + Temp probe
Cooling
BeQuiet SilentWings 3 High Speed PWM x 9
Case
Lian Li PC-O11 Dynamic
Operating System
Windows 10 Pro
Monitor
LG 27" IPS 27UK650
Keyboard
Massdrop CTRL
Mouse
Logitech g403
Mousepad
HAYATE KOU FX SOFT NINJA Black L
Audio
Blue Yeti Black
Audio
Massdrop x AKG K7XX
Other
LIAN LI O11D-1X ,Riser Cable and cover bracket for PC-O11D
CPU
i5 3570k
Motherboard
Z77x-UD5H
GPU
Zotac 670 GTX AMP!
RAM
G.Skill f3-2400c10D-16gtx
Hard Drive
Samsung 850 Pro 128GB
Optical Drive
Some old thing
Power Supply
Seasonic platinum 860w
Cooling
Custom water
Case
Customized Thermaltake Armor
Operating System
Win 10 pro
Monitor
Dell U2413
Keyboard
Ducky Shine
Mouse
Logi G502
▲ hide details ▲


ryan92084 is offline  
Sponsored Links
Advertisement
 
post #4 of 19 (permalink) Old 02-11-2018, 07:13 AM
 
 
gonX's Avatar
 
Join Date: May 2006
Location: Odense, Denmark
Posts: 29,522
Closing and cross-referencing: https://www.overclock.net/forum/17793...-old-post.html

What does OCN offer as a site?
What are infractions and warnings?
How to make quality posts
#well
(19 items)
CPU
Intel Core i7 4770k
Motherboard
Gigabyte Z87X-UD4H
GPU
Sapphire RX 580
RAM
2x G.Skill F3-2400C10-8GTX
Hard Drive
Samsung 840 EVO
Optical Drive
Generic DVD±RW Burner
Power Supply
Corsair TX850
Cooling
Noctua NH-D14
Case
Fractal Design Core 2500
Operating System
Arch Linux
Monitor
Dell U2711
Monitor
Samsung SyncMaster 2233
Monitor
LG W2453TQ
Keyboard
Ducky DK9008G2, Cherry MX Blue, Overclock.net Edition
Mouse
Logitech G303
Mouse
Xtrfy GP3 HeatoN
Audio
Beyerdynamic DT-770 80 Ohm
Audio
AntLion ModMic v3
Audio
M-Audio Fast Track USB
▲ hide details ▲


gonX is offline  
post #5 of 19 (permalink) Old 03-09-2018, 11:47 AM
VS Guy
 
Overclock_Admin's Avatar
 
Join Date: Aug 2017
Posts: 636
Confirmed and case opened

Case #2982136

Jeff M

Testing Rig
(0 items)
▲ hide details ▲
Overclock_Admin is offline  
post #6 of 19 (permalink) Old 04-13-2018, 09:27 AM
VS Guy
 
Overclock_Admin's Avatar
 
Join Date: Aug 2017
Posts: 636
Quote: Originally Posted by Overclock_Admin View Post
Confirmed and case opened

Case #2982136

Jeff M
Followup question from Ops team.

"Does that happen when editing every post or just ones with links and special characters in them? If you type a really long word in the post (over 50 characters like a link) and then edit that does it still give you the error?"

Jeff M

:
Testing Rig
(0 items)
▲ hide details ▲
Overclock_Admin is offline  
post #7 of 19 (permalink) Old 04-18-2018, 01:03 AM - Thread Starter
New to Overclock.net
 
LostParticle's Avatar
 
Join Date: Aug 2014
Posts: 2,543
Rep: 98 (Unique: 75)
Hi,

This error continues. In the attached screenshot you can see some text I've copied & pasted, it is from Greek, Norwegian and Hungarian newspaper websites. All of this text contains special characters, as you can see. When I press "Post Quick Reply" I get the Database error as shown in the first post.

EDIT: Well... I honestly don't know what's going on! I was getting the Database error right after trying to post these Special Characters posts but when I reloaded the page the posts appeared! I don't know what's going on...
Attached Thumbnails
Click image for larger version

Name:	spec.png
Views:	8
Size:	192.0 KB
ID:	152969  


Intel Core i7-4790K
(27 items)
CPU
Intel Core i7-4790K
Motherboard
ASRock Z97 OC Formula; ASUS MAXIMUS VII HERO; Gigabyte Z97X-SOC Force
GPU
EVGA GTX 1060 SC GAMING 6 GB
RAM
G.SKILL F3-1866C8D-16GTX
Hard Drive
Samsung 850 EVO 250 GB
Hard Drive
SanDisk Extreme Pro 240GB
Hard Drive
Samsung 840 PRO 128GB
Hard Drive
Plextor PX-128M5S 128GB
Hard Drive
WD 1002FAEX 1TB Caviar BLACK (in enclosure)
Power Supply
Corsair AX760 (Platinum); EVGA SuperNova 750 G2
Cooling
Corsair H110
Cooling
2 x Noctua NF-A14 industrialPPC-2000/3000 PWM (Push)
Cooling
Case Fan: 1 x Noctua NF-A14 PWM (rear, exhaust)
Cooling
Case Fan: Noctua NF-S12A PWM (front, intake)
Cooling
Case Fans: 2 x Noctua NF-S12A FLX (front, intake)
Cooling
Noctua NH-D15S
Case
Corsair Air 540
Operating System
Windows 10 Pro 64 bit
Operating System
Windows 10 TP
Operating System
Linux Mint 18.3 Cinnamon
Monitor
HP ZR2440w
Monitor
Dell U2311H
Keyboard
Microsoft Ergonomic keyboard 4000
Audio
Sennheiser HD 600
Audio
Asus Xonar Essence STX II
Other
Aquaero 5LT
Other
THRUSTMASTER GPX LIGHTBACK FERRARI F1 GAMEPAD
▲ hide details ▲

Last edited by LostParticle; 04-18-2018 at 01:10 AM.
LostParticle is offline  
post #8 of 19 (permalink) Old 04-18-2018, 01:11 AM - Thread Starter
New to Overclock.net
 
LostParticle's Avatar
 
Join Date: Aug 2014
Posts: 2,543
Rep: 98 (Unique: 75)
δφγδφγδφγσδφγσδφγσδφγσδφγ σδφγ


Okay, so here is what I observe, at least on my system: when I post the above characters I get the error. Then when I go back to the page, right afterwards, I see my post, posted. That is what happens on my system. The same happens when I edit this post. "Save Changes" produces the error. I then go back and I see my post, updated.

Intel Core i7-4790K
(27 items)
CPU
Intel Core i7-4790K
Motherboard
ASRock Z97 OC Formula; ASUS MAXIMUS VII HERO; Gigabyte Z97X-SOC Force
GPU
EVGA GTX 1060 SC GAMING 6 GB
RAM
G.SKILL F3-1866C8D-16GTX
Hard Drive
Samsung 850 EVO 250 GB
Hard Drive
SanDisk Extreme Pro 240GB
Hard Drive
Samsung 840 PRO 128GB
Hard Drive
Plextor PX-128M5S 128GB
Hard Drive
WD 1002FAEX 1TB Caviar BLACK (in enclosure)
Power Supply
Corsair AX760 (Platinum); EVGA SuperNova 750 G2
Cooling
Corsair H110
Cooling
2 x Noctua NF-A14 industrialPPC-2000/3000 PWM (Push)
Cooling
Case Fan: 1 x Noctua NF-A14 PWM (rear, exhaust)
Cooling
Case Fan: Noctua NF-S12A PWM (front, intake)
Cooling
Case Fans: 2 x Noctua NF-S12A FLX (front, intake)
Cooling
Noctua NH-D15S
Case
Corsair Air 540
Operating System
Windows 10 Pro 64 bit
Operating System
Windows 10 TP
Operating System
Linux Mint 18.3 Cinnamon
Monitor
HP ZR2440w
Monitor
Dell U2311H
Keyboard
Microsoft Ergonomic keyboard 4000
Audio
Sennheiser HD 600
Audio
Asus Xonar Essence STX II
Other
Aquaero 5LT
Other
THRUSTMASTER GPX LIGHTBACK FERRARI F1 GAMEPAD
▲ hide details ▲
LostParticle is offline  
post #9 of 19 (permalink) Old 04-18-2018, 04:13 AM
News Fiend
 
ryan92084's Avatar
 
Join Date: Oct 2015
Location: 'merica
Posts: 2,005
test 2.0 μ Δ θ

edit: Same as Last Particle. When making or editing a post containing special characters you get the error message but when you go back to the thread the post/edit has worked.

Meh '12
(13 items)
CPU
Ryzen 2600x
Motherboard
ASUS Crosshair VII Hero
GPU
XFX Fury X
RAM
G.SKILL TridentZ Series 16GB (2 x 8GB) 288-Pin DDR4 SDRAM DDR4 3200 F4-3200C14D-16GTZSW
Hard Drive
SAMSUNG 970 PRO M.2 2280 512GB PCIe Gen3. X4, NVMe
Hard Drive
Samsung 850 Pro-Series
Hard Drive
Seagate 4TB Enterprise NAS SATA (ST4000VN0001)
Hard Drive
WD Black 1TB Performance Desktop Hard Drive WD1003FZEX
Power Supply
SEASONIC PLATINUM-860 860W RT
Cooling
Black Ice Nemesis 360GTS Radiator x2
Cooling
Monsoon MMRS Reservoir + D5 pump + mountings
Cooling
XSPC Raystorm Neo Metal
Cooling
EKWB Fury X
Cooling
Monsoon Free Center 1/2ID 3/4OD fittings + Rotaries + plug + Temp probe
Cooling
BeQuiet SilentWings 3 High Speed PWM x 9
Case
Lian Li PC-O11 Dynamic
Operating System
Windows 10 Pro
Monitor
LG 27" IPS 27UK650
Keyboard
Massdrop CTRL
Mouse
Logitech g403
Mousepad
HAYATE KOU FX SOFT NINJA Black L
Audio
Blue Yeti Black
Audio
Massdrop x AKG K7XX
Other
LIAN LI O11D-1X ,Riser Cable and cover bracket for PC-O11D
CPU
i5 3570k
Motherboard
Z77x-UD5H
GPU
Zotac 670 GTX AMP!
RAM
G.Skill f3-2400c10D-16gtx
Hard Drive
Samsung 850 Pro 128GB
Optical Drive
Some old thing
Power Supply
Seasonic platinum 860w
Cooling
Custom water
Case
Customized Thermaltake Armor
Operating System
Win 10 pro
Monitor
Dell U2413
Keyboard
Ducky Shine
Mouse
Logi G502
▲ hide details ▲


ryan92084 is offline  
post #10 of 19 (permalink) Old 04-20-2018, 12:22 PM
VS Guy
 
Overclock_Admin's Avatar
 
Join Date: Aug 2017
Posts: 636
10-4,

Updated Ticket # 2982136 with the new details

Thanks,
Jeff M

:
Testing Rig
(0 items)
▲ hide details ▲
Overclock_Admin is offline  
Reply

Quick Reply
Message:
Options

Register Now

In order to be able to post messages on the Overclock.net - An Overclocking Community forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.
User Name:
If you do not want to register, fill this field only and the name will be used as user name for your post.
Password
Please enter a password for your user account. Note that passwords are case-sensitive.
Password:
Confirm Password:
Email Address
Please enter a valid email address for yourself.
Email Address:

Log-in



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page


Forum Jump: 

Posting Rules  
You may not post new threads
You may 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
Trackbacks are Off
Pingbacks are Off
Refbacks are Off