You have an UNIQUE index on (content, ref_id), called editor_contentmodel_content_2192f49c_uniq
"editor_contentmodel_content_2192f49c_uniq" UNIQUE CONSTRAINT, btree (content, ref_id)
I'm not sure why this there to begin with. So let's step back and address what this does. This makes sure that ...
So if the string is a column name and all characters appear to be "normal" (Latin letters (without accents), an underscore, a digit), why could there be more bytes than chars?
@ypercubeᵀᴹ Not sure if we should but your suggestion really makes much sense. Perhaps we should just point out the difference, explain the likely implication and leave the digging to the OP.
Not very active as an answerer or asker. But has been 2 years and 3 months here, more than on any of the other sites where he's got more rep (except for Android, where it's 2 yr 3 mn as well). But, good gracious, registered in 147 communities! So enthusiastic.
@ypercubeᵀᴹ Is there a ranking page on that or did you just use SEDE to find out?
Today a customer couldn't change inventory on a product any more, [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting numeric to data type numeric.
turns out the inventory on that item was currently valued at 9 696 506 928 381 040,00 so an extra addition made the type overflow
It is a bit late into this new year, being that we're already in the second month, but we are now cycling the Community Promotion Ads for 2017!
What are Community Promotion Ads?
Community Promotion Ads are community-vetted advertisements that will show up on the main site, in the right sidebar....
The error message is quite clear. The table krneki_2 does not have a column named id_naslov. Unless there is some corruption in system tables or a bug, there is no question about that.
So we have to eliminate several possibilities why this appears:
There are mismatches between the CREATE TAB...
It is a bit late into this new year, being that we're already in the second month, but we are now cycling the Community Promotion Ads for 2017!
What are Community Promotion Ads?
Community Promotion Ads are community-vetted advertisements that will show up on the main site, in the right sidebar....
@FelixRosén check activity with whoisactive, it may be blocked, it may be running an update/processing task, apart from that it's just guessing (or killing and restarting to run into the same issue)
When i ran myphpadmin through xampp it first complained about the size of the file, it worked when i did it throught the commandline though. But now i got wamp and tried to import it through myphpadmin there instead, and its only loading (taking up like 30% of my cpu). Maybe I should cancel it and do it through the command line?
FROM command syntax error :( Is there any possibility of OUTER APPLY doesn't works in MS Query on excel files (as the data base)?? I ask because I've tried to do the simplest queries and get the same error — Julio Maldonado Henríquez57 mins ago
@ypercubeᵀᴹ and you end up with would you like to continue this discussion in chat?
Hi there, MS query can connect to a number of data sources, Paradox, SQL Server, Text files whatever. Are you using MS Query to connect to any of those, or to connect to another Excel file? — Tom V14 secs ago
In any case, he's in for a headache if he's using MS query to load data into excel files
wait until he finds out SQL Server dates aren't recognized as dates in Excel until you cast them to datetime :)
My pivot pulls from an external data source with a date column. Excel doesn't see this column as a date and the 'Format Cells' option panel doesn't change how the dates are displayed. The cell data is left-aligned, suggesting a string rather than a date. I have tried cast(myvar as date) and conve...
As an example ETH Zurich, which is arguably one of the best universities in Europe, still educates Bachelor's students in German:
Please note: the Bachelor’s degree programmes begin in German. In the second and third years of the programmes, some of the courses may take place in English.
Th...
@EvanCarroll you are mostly active on the postgres tags — votes here are in line with traffic and SQL Server and MySQL posts get a lot more votes I think
We need more PostgreSQL users to FIGHT THE BORG. =P
In fairness, I use Google Chrome RSS feed. So I'm not that active on this site for anything else. Specifically, I'm only tagged when something pops up with postgresql, or postgis.
@JackDouglas Agreed, votes are in line with the audience/traffic, I only upvote questions really obviously well written or difficult in subjects I know nothing about
in SQL Server I get "hey that's a good question" while in for ex postgres I am "meh, no idea if that's obvious or not"
It always confused me why people didn't upvote questions more often that they were answering. I think that should be worked into the UI of the site more.
You could imagine a Submit Answer, with a Submit Answer and Upvote Question button visible next to it if you haven't upvoted yet.
@wBob I can't think of a single question I answered but didn't UV (unless Paul proves me wrong) but if I think it's worth answering it's worthy of an upvote
2
I tend to live by that rule, with one or two exceptions I remember where I thought "I'll help that guy out" and then VtC as too localized anyway
@EvanCarroll Not sure, the answer could solve the problem and still be crap, so there could (theoretically) be a situation where you even accept and downvote
Not necessarily, just a wall of code without explanation doesn't help anyone but the OP, so that might be accepted but might not get an upvote for being a good answer
The irony of it all is that I remember posting an answer to a question just to help the guy out, and then VtC, and my crappy answer got some upvotes probably from being in the review queue
None of that means the system is flawed, I had to learn that too
Reminds me of searching for a Dynamics login issue, and seeing a suggestion to delete everything in the Users table through SQL. And seeing people say that helped them.
When I was a noob on this site, I thought the voting on individual questions had to be fair, I learned it isn't necessarily, but it still is in the long run evening out
@Forrest That doesn't happen that often on our subsite
Erik, who isn't around in the room often once replied this to a meta question of mine, and his comment rightfully got more upvotes than my question
Sometimes we get lots of votes for a basic answer and sometimes we write a masterpiece to have it languish. Overall I think things balance out. If it will make you feel better you should find a really hard unanswered question and figure out a great answer. — ErikNov 17 '15 at 0:17
@EvanCarroll At the time I tried, and failed, too. I now tend to focus on subjects that don't get a lot of attention (and I know at least something about) such as mdw, dynamics, SSRS etc
Those tags aren't upvoting magnets either, but at least they help somebody out and I try to answer in a generic way if/when possible
I never joined for the personal rep, my joy is in learning something new myself from solving other peoples problems
Which is still egoistic, but everybody does stuff mostly to benefit their selves I suppose
In PostgreSQL we have a name it INSERT ... RETURNING.
You can use this form in a CTE to obtain the effect you want..
CREATE TABLE foo ( foo serial, bar int );
WITH t1 AS (
SELECT x
FROM generate_series(1,10) AS t(x)
),
t2 AS (
INSERT INTO foo (bar)
SELECT x
FROM t1
WHERE NOT EXIST...
How long until the borg hunts it down and tries to destroy it
@TomV personally, I look at every question. I don't have much time at the minute, but I used to answer ones I could, others I found interesting and didn't know I'd research and answer. Except the MySQL ones. @ypercubeᵀᴹ answers them ❤️
It is a bit late into this new year, being that we're already in the second month, but we are now cycling the Community Promotion Ads for 2017!
What are Community Promotion Ads?
Community Promotion Ads are community-vetted advertisements that will show up on the main site, in the right sidebar....
The error message is quite clear. The table krneki_2 does not have a column named id_naslov. Unless there is some corruption in system tables or a bug, there is no question about that.
So we have to eliminate several possibilities why this appears:
There are mismatches between the CREATE TAB...
As an example ETH Zurich, which is arguably one of the best universities in Europe, still educates Bachelor's students in German:
Please note: the Bachelor’s degree programmes begin in German. In the second and third years of the programmes, some of the courses may take place in English.
Th...
