Can't post to the STEX

[smf_16 1,834]

Hi guys, I just tried twice to upload a new file to the STEX, but I received an SQL error:

 

 

SQL Error

An error occured with the SQL server:

mySQL query error: SELECT s.*, s.id as row_session_id,m.* FROM sessions s LEFT JOIN members m ON ( m.member_id=s.member_id ) WHERE s.id='f89074514557bb486b83cc977d0ce2c3' OR (s.current_appcomponent='downloads' AND s.running_time > 1360344544 AND s.in_error=0)

This is not a problem with the IPS Community Suite but rather with your SQL server. Please contact your host and copy the message shown above

Now, the file shows up on the home page, but the same error is shown.

 

Thought I'd let the admins know!

 

EDIT: Okay, now both tries to upload show up on the home page, but both link to the same SQL error. However, if I go to "My Content", I get to see a preview of both, but clicking on it redirects me to the same SQL error... What is going on here?

[Dirktator 2,310]

Yeh, there's definitely something strange with your file ... looking into it. 

[smf_16 1,834]

Thanks. Just let me know if I have to re-upload it

[smf_16 1,834]

Could it be that it's an issue with my account? The issue was fixed, but then I posted a reaction and again: SQL error...

[Dirktator 2,310]

Could it be that it's an issue with my account? The issue was fixed, but then I posted a reaction and again: SQL error...

 

Still addressing it, I believe mysql is hitting a limit for that particular kind of query...

[Dirktator 2,310]

I believe it's resolved now. I can now load your file without the error:

 

 

You may want to re-upload the thumbnail and set it as the main thumb so it gets regenerated in the stex listing...

[smf_16 1,834]

Allright, I just edited the file, and now the main thumb is showing in the listing. It takes some time to load the page though...

Thanks for fixing the issue!