item mall

04/10/2013 14:05 zackfail#1

Hola amigos, de nuevo solicitando su ayuda, ya que cuando intento cambiar el item mall me sale un error, ya borre lo que tenia anterior mente y nada :c, y cuando intento y intento me sale el mismo error, les dejo una imagen para que vean, si alguien me puede ayudar gracias :c.
[Only registered and activated users can see links. Click Here To Register...]

04/10/2013 14:32 andr3y_you96#2

from where di you got that query o.O
its should be something like this

Quote:

INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('30 Day Items','1',0,100043,1,100051,1,100053,1,100056,1,1 00072,1,100073,1,100074,1,100075,1,100076,1,100165 ,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0)

04/10/2013 21:55 zackfail#3

Quote:

Quote:
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('30 Day Items','1',0,100043,1,100051,1,100053,1,100056,1,1 00072,1,100073,1,100074,1,100075,1,100076,1,100165 ,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0)

nada u.u

04/11/2013 03:08 killer870#4

zackfail, la secuencia de comando (script) deve tener primero donde es donde vas a actualizar, es decir la tabla. Que en este case seria la tabla [PS_GameDefs].[dbo].[ProductList] ... y deve decir asi para ke sepa donde (INSERT INTO [PS_GameDefs].[dbo].[ProductList]) <- siempre deve comenzar asi ya de ahi se le ponen el valor ke vas a actualizar que en este caso por ejemplo deve ser (('30 Day Items','1',0,100043,1,100051,1,100053,1,100056,1,1 00072,1,100073,1,100074,1,100075,1,100076,1,100165 ,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0)) ese ejemplo le pone en la tabla ke el primer item en el item amll se llama "30 Day Items"..etc. Pero para que se te aga mas facil, te sujiero ke uses el programa llamado sHStudio, que se encuentra [Only registered and activated users can see links. Click Here To Register...], necesitas saver como usarlo y en ese tema te explica muy bien

04/11/2013 11:52 zackfail#5

es el que intento usar pero no me sirve :c

04/11/2013 13:25 zokylove#6

i dont understand what u guys saying but the answer is simple.
Just add

Code:

USE [PS_GameDefs]

in first line of your query.

04/11/2013 18:39 killer870#7

Quote:
Originally Posted by zokylove
i dont understand what u guys saying but the answer is simple.
Just add
Code:
USE [PS_GameDefs]
in first line of your query.

Hi zokylove, yes i already explained to him that part on the last post, and told him he should use the shstudio program but according to him it doesnt work. lol i think hes doing some things wrong or still doesnt have good knowledge about how to use it

Quote:

Originally Posted by zackfail

es el que intento usar pero no me sirve :c

zack porque dices que no funsiona?, te da el script o no?, para usarlo deves tener el Cash.sdata abierto con ese programa, y cuando lo abra de ahi debes hacer los cambios, y cuando le haces click a Save (guardar), el script te deve salir automaticamente en la carpeta donde configuraste que se aguarde

04/11/2013 20:49 castor4878#8

<< Just add USE [PS_GameDefs] >>
incorrect, the error msg is NOT "base / table not found".

<< use the shstudio program but according to him it doesnt work >>
shStudio does word, but it does not replace the user's brain (already explained too).

the error message is "THE NUMBER OF COLUMNS DO NOT MATCH" !!
is it that hard to read ???

I already explain, several times, that some tables around there do contain an identity RowID column and other don't contain it, or don't set it as identity.

the SQL script generated by shStudio can NOT contain more information - it can NOT be more comprehensible not understandable - because it does include the name of used columns -- the first advice "INSERT INTO [PS_GameDefs].[dbo].[ProductList] values (foo, bar, thing)" was a bad mind since it miss these columns name and thus does a lot of assumptions.

so compare your table structure with the insert statement and fix your table.

wrong assumption

04/11/2013 21:14 zokylove#9

Quote:

Originally Posted by castor4878

<< Just add USE [PS_GameDefs] >>
incorrect, the error msg is NOT "base / table not found".

<< use the shstudio program but according to him it doesnt work >>
shStudio does word, but it does not replace the user's brain (already explained too).

the error message is "THE NUMBER OF COLUMNS DO NOT MATCH" !!
is it that hard to read ???

I already explain, several times, that some tables around there do contain an identity RowID column and other don't contain it, or don't set it as identity.

the SQL script generated by shStudio can NOT contain more information - it can NOT be more comprehensible not understandable - because it does include the name of used columns -- the first advice "INSERT INTO [PS_GameDefs].[dbo].[ProductList] values (foo, bar, thing)" was a bad mind since it miss these columns name and thus does a lot of assumptions.

so compare your table structure with the insert statement and fix your table.

Talking about the brain.exe castor i used google translator and translated this part:

Code:

No se encuentra el objeto "ProductList" porque no existe o no tiene permision.

Table ProductList do not exist or user dont have permision,so or hi using the wrong database,or user dont have owner permision.And if u take a carefull look at pic hi is trying to run the query using master db.

04/12/2013 02:50 killer870#10

Actually the Error Msg says "El Nombre de Objeto [Productlist] no es valido" or "the Name of object [Productlist] is not valid... still not sure if thats what you were reffering to castor, if it wasnt then disregard this. But everything else.... yes indeed you are right

04/13/2013 00:47 castor4878#11

You are both right, sorry for my mistake.

This is actually, once again, the perfect prototype of a question for which several persons spend time to imagine all possible conditions and propose solutions while only the author can know the exact reason of his error and would be a great effort of about 5 seconds to fix it ... once again.

the combo present in the SQL editor icon-bar indicates that the "master" schema is selected, and zack would need 5 sec. to select the right base.

09/03/2013 21:58 ruben palomino#12

mira
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('30 Day Items','1',0,100043,1,100051,1,100053,1,100056,1,1 00072,1,100073,1,100074,1,100075,1,100076,1,100165 ,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0)
en ese esta bien pero le falta una cosa realmente es asi
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('30 Day','Items','1',0,100043,1,100051,1,100053,1,1000 56,1,100072,1,100073,1,100074,1,100075,1,100076,1, 100165 ,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0)

09/03/2013 23:54 AxelMac#13

this problem is because instead of Master had to select PS_GameDefs would do this if the problem would not have found, for a correct use ShStudio use the cash that works 100%

09/04/2013 00:17 ruben palomino#14

ESTO FUNCIONA ASI
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('30','Day Items','1',0,100043,1,100051,1,100053,1,100056,1,1 00072,1,100073,1,100074,1,100075,1,100076,1,100165 ,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0)
solo debes agregar despues del primer nombre ',' esto y ya esta :)